权限组操作

select m1.id,m1.url,m1.name,m2.id as id2,m2.url as url2,m2.name as name2,m3.id as id3,m3.url as url3,m3.name as name3
from menu m1,menu m2,menu m3 //查询菜单表三次
where m1.id=m2.parentId      //查询父子关系
and m2.id=m3.parentId        //查询父子关系

    @RequestMapping("/getMenuTree/{rid}")
    public HashMap<String, Object> getMenuTree(@PathVariable Integer rid){
        List<Menu> menuTree = menuService.getMenuTree();
        List<Integer> mids = menuService.getMenuByRid(rid);
        HashMap<String, Object> map = new HashMap<>();
        map.put("menuTree",menuTree);
        map.put("mids", mids);
        return map;
    }