mybatis嵌套查询

类中包含自己

@Data
public class SubjectVo {
    private String id;
    private int sort;
    private  String title;
    private List<SubjectVo> children=new ArrayList<>();

}



<resultMap id="nectList2" type="com.atguigu.guli.service.edu.entity.vo.SubjectVo">
        <result column="id" jdbcType="VARCHAR" property="id" />
        <result column="sort" jdbcType="INTEGER" property="sort" />
        <result column="title" jdbcType="VARCHAR" property="title" />

       <collection property="children" column="id"  ofType="com.atguigu.guli.service.edu.entity.vo.SubjectVo"  select="selectnectList2"></collection>
    </resultMap>
    <select id="selectnectList2" resultMap="nectList2">
        select id,sort,title from edu_subject where parent_id=#{id}
    </select>

@Data
public class ChapterVo implements Serializable {

    private static final long serialVersionUID = 1L;

    private String id;
    private String title;
    private Integer sort;
    private List<VideoVo> children = new ArrayList<>();
}


 <resultMap id="nectList2" type="com.atguigu.guli.service.edu.entity.vo.ChapterVo">
        <result column="id" jdbcType="VARCHAR" property="id" />
        <result column="sort" jdbcType="INTEGER" property="sort" />
        <result column="title" jdbcType="VARCHAR" property="title" />

        <collection property="children" column="id"  ofType="com.atguigu.guli.service.edu.entity.vo.VideoVo"  select="selectVideoList"></collection>
    </resultMap>
    <select id="getChapterBycourseId" resultMap="nectList2">
        select id,title,sort from edu_chapter where course_id=#{courseid}
    </select>

类中不包含自己