mybatis 子查询案例

    <resultMap id="pageMap" type="com.service.erp.vo.ErpShopVo">
        <result column="ID" property="id"></result>
       <association property="members" javaType="java.util.List"  select="listMember"   column="{ID=ID}" >
        </association>
    </resultMap>

    <select id="selectPageVo" resultMap="pageMap" >
            select *  FROM erp_shop WHERE del_flag='0'
    </select>
    <resultMap id="memberMap" type="java.util.Map">
        <result column="NICKNAME"  property="nickName"></result>
        <result column="MEMBER_ID" property="memberId"></result>
        <result column="SHOP_ROLE" property="shopRole"></result>
    </resultMap>

    <select id="listMember" resultType="java.util.Map"  resultMap="memberMap">
        SELECT
          sm.MEMBER_ID,sm.NICKNAME,sm.SHOP_ROLE
        FROM
        erp_shop_member sm
        WHERE
        sm.SHOP_ID = #{ID} and sm.SHOP_ROLE = 1
 </select>