mybatis递归查询父子菜单

前端Vue.js的查询结果

 //这是树状图的测试数据
      treeData: [
        {
          id: "1",
          label: "一级 1",
          parentId: "",
          status: "",
          version: "",

          children: [
            {
              id: "1",
              label: "二级 1-1",
              parentId: "",
              status: "",
              version: "",
              children: [
                {
                  id: "1",
                  label: "二级 1-1",
                  parentId: "",
                  status: "",
                  version: ""
                }
              ]
            }
          ]
        }
      ],

数据库截图

返回模型

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;


import java.io.Serializable;
import java.util.List;

/**
 * @ClassName: TreeEntity
 * @Description: ${description}
 * @Author: lang
 * @Date: 2020/3/20 13:37
 * @Version: v1.0
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class TreeEntity implements Serializable {
    private static final long serialVersionUID = 327227539516248064L;
    private String id;
    private String label;

    private String parentId;
    private Integer status;
    private String remark;
    private String version;

    private List<TreeEntity> children;
}

mapper 语句

public interface TreeMapper
{
    public List<TreeEntity> selectAllMenu(Long id);//查询树菜单
}

mybatis语句

 <!--级联查询返回模型-->
    <resultMap type="boss.bes.basedata.entity.TreeEntity" id="fatherMap">
        <id column="id" property="id"/>
        <id column="name" property="label"/>
        <id column="parent_id" property="parentId"/>
        <id column="status" property="status"/>
        <id column="version" property="version"/>
        <id column="remark" property="remark"/>
        <collection property="children" ofType="boss.bes.basedata.entity.TreeEntity" column="id"
                    select="findMenuByPid"/>
    </resultMap>

    <!--级联查询父菜单-->
    <select id="selectAllMenu" resultMap="fatherMap">
        select id,name,parent_id,status,version,remark
        from t_category
        where parent_id = 0
    </select>

    <!--级联查询子菜单-->
    <select id="findMenuByPid" parameterType="java.lang.Long" resultMap="fatherMap">
        select id,name,parent_id,status,version,remark
        from t_category
        where parent_id = #{id}
    </select>