<select id="front.sort.selectListall" parameterType="myshop.services.front.sort.bean.sort" resultMap="sortResultMap">
    select one.*,tw.id sid,tw.catlevel slevel,tw.name sname,tw.code scode,thr.id
    tid,thr.catlevel tlevel,thr.name as tname, thr.code as tcode 
    from tb_sort
    one join tb_sort tw on tw.pid=one.id join tb_sort thr on thr.pid=tw.id
    order by one.order1,tw.order1,thr.order1
</select>
<resultMap id="sortResultMap" type="myshop.services.front.sort.bean.Sort">
    <id property="id" column="id" />
    <result property="catlevel" column="catlevel" />
    <result property="code" column="code" />
    <result property="name" column="name" />
    <collection property="children" ofType="myshop.services.front.sort.bean.Sort">
        <id property="id" column="sid" />
        <id property="catlevel" column="slevel" />
        <id property="code" column="scode" />
        <id property="name" column="sname" />
        <collection property="children" ofType="myshop.services.front.sort.bean.Sort">
            <id property="id" column="tid" />
            <id property="catlevel" column="tlevel" />
            <id property="name" column="tname" />
            <id property="code" column="tcode" />
        </collection>
    </collection>
</resultMap>

实体类接收数据：

private List<Sort> children;