实体类

    private Integer id;

    private Integer fatherId;

    private String name;

    private Integer deleteFlag;

    private Date createTime;

    private List<Stfl> child; //子节点

service层

List<Stfl> getTreeStfl (Integer id,Integer deleteFlag);

serviceImpl层

    @Override
    public List<Stfl> getTreeStfl(Integer id, Integer deleteFlag) {
        return stflMapper.getTreeStfl(id,deleteFlag);
    }

 dao层

List<Stfl> getTreeStfl(@Param("id") Integer id, @Param("deleteFlag") Integer deleteFlag);

xml

<resultMap id="treeStfl" type="com.lc.pxpt.model.Stfl">
    <id column="id" property="id"></id>
    <result column="father_id" property="fatherId"></result>
    <result column="name" property="name"></result>
    <result column="delete_flag" property="deleteFlag"></result>
    <result column="create_time" property="createTime"></result>
    <collection property="child" column="{id=id,deleteFlag=delete_flag}" ofType="com.lc.pxpt.model.Stfl" select="getTreeStfl"></collection>
  </resultMap>
  <select id="getTreeStfl" resultMap="treeStfl">
    SELECT
     id, father_id, name, delete_flag, create_time
     FROM stfl WHERE delete_flag = #{deleteFlag} AND father_id = #{id}
  </select>

    <!-- 
        <collection property="child" column="{属性名=列名,属性名=列名}" ofType="com.lc.pxpt.model.Stfl" select="getTreeStfl"></collection>
    -->