mybatis一对多映射(2022)返回树形结构

 核心XML编写:

<select id="findDetailById" parameterType="int" resultMap="setmealDetailMap">
    select s.*,
         sc.checkgroup_id, g.name checkgroup_name, g.remark checkgroup_remark,g.helpCode checkgroup_code,
         cc.checkitem_id, c.name checkitem_name,c.age checkitem_age
    from t_setmeal s, t_setmeal_checkgroup sc, t_checkgroup g,
         t_checkgroup_checkitem cc, t_checkitem c
    where s.id=sc.setmeal_id and sc.checkgroup_id=g.id
          and g.id=cc.checkgroup_id and cc.checkitem_id=c.id
          and s.id=#{id}
</select>
<resultMap id="setmealDetailMap" type="setmeal">
    <id property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="code" column="code"/>
    <result property="helpCode" column="helpCode"/>
    <result property="sex" column="sex"/>
    <result property="age" column="age"/>
    <result property="price" column="price"/>
    <result property="remark" column="remark"/>
    <result property="attention" column="attention"/>
    <result property="img" column="img"/>
    <collection property="checkGroups" ofType="CheckGroup">
        <id property="id" column="checkgroup_id"/>
        <result property="name" column="checkgroup_name"/>
        <result property="remark" column="checkgroup_remark"/>
        <result property="helpCode" column="checkgroup_code"/>
        <collection property="checkItems" ofType="CheckItem">
            <id property="id" column="checkitem_id"/>
            <result property="name" column="checkitem_name"/>
            <result property="age" column="checkitem_age"/>
        </collection>
    </collection>
</resultMap>