MyBatis与mysql内接关联查询

<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE mapper
 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.ask.mapper.OrderCustomMapper"> 
  <resultMap type="com.ask.pojo.OrderCustom" id="orderCustom">
      <id column="id" property="id"/>
      <result column="user_id" property="user_id"/>
      <result column="number" property="number"/>
      <result column="createTime" property="createTime"/>
      <result column="note" property="note"/>
      <result column="username" property="name"/>
      <result column="address" property="address"/>
  </resultMap>
  <!-- 内接关联查询 -->
   <select id="getOrderAndUser" resultMap="orderCustom">
      SELECT 
 o.*,
 u.username,
 u.address 
FROM
 orders o,
 USER u 
WHERE o.user_id = u.id 
   </select>

 </mapper>