三级联查

dao:
List<UserDto> selectRole(long id);
List<UserDto> selectU(long id);

service:
List<UserDto> selectRole(long id);
List<UserDto> selectU(long id);

serviceImpl:
@Override
public List<UserDto> selectRole(long id) {
    return userDao.selectRole(id);
}
@Override
public List<UserDto> selectU(long id) {
    return userDao.selectU(id);
}

@GetMapping("/selectU/{id}/")
@ApiOperation("id用户信息")
@RequiresPermissions("sys:user:selectU")
public Response selectU(@PathVariable("id") Integer id){
    List<UserDto> userDtos = userService.selectU(id);

    return Response.ok().put("user",userDtos);
}

controller:
/**
 * id查询用户
 */
@GetMapping("/selectRole/{id}/")
@ApiOperation("id查询用户信息")
@RequiresPermissions("sys:user:selectRole")
public Response selectRole(@PathVariable("id") Integer id){
    List<UserDto> userDtos = userService.selectRole(id);

    return Response.ok().put("user",userDtos);
}

<!--根据用户id查询用户信息-->
<!--1、根据用户查询日志、角色-->
<resultMap id="UserMap" type="com.kryh.sys.dto.UserDto">
    <result property="id" column="id"/>
    <result property="username" column="username"/>
    <result property="mobile" column="mobile"/>
    <result property="password" column="password"/>
    <result property="createTime" column="create_time"/>
    <collection property="logs" ofType="com.kryh.sys.dto.LogDto" column="id" select="getLog"/>
    <collection property="roles" ofType="com.kryh.sys.dto.RoleDto" column="id" select="selectRole"/>
</resultMap>

<!--日志信息-->
<resultMap id="LogMap" type="com.kryh.sys.dto.LogDto">
    <id property="id" column="id"/>
    <result property="type" column="type"/>
    <result property="name" column="name"/>
    <!--<result property="datetime" column="time" javaType="DateTime" jdbcType="Date"/>-->
    <result property="content" column="content"/>
    <result property="uid" column="uid"/>
</resultMap>

<!--角色信息查询菜单信息-->
<resultMap id="RoleMap" type="com.kryh.sys.dto.RoleDto">
    <id property="id" column="id"/>
    <result property="mc" column="mc"/>
    <result property="parentId" column="parent_id"/>
    <collection property="menus" ofType="com.kryh.sys.dto.MenuDto" column="id" select="selectMenu"/>
</resultMap>

<!--菜单信息-->
<resultMap id="MenuMap" type="com.kryh.sys.dto.MenuDto">
    <id property="id" column="id"/>
    <result property="cd" column="cd"/>
    <result property="cjsj" column="cjsj"/>
    <result property="scsj" column="scsj"/>
    <result property="ml" column="ml"/>
    <result property="parentId" column="parent_id"/>
    <result property="route" column="route"/>
</resultMap>


<!--查询日志-->
<select id="getLog" resultMap="LogMap">
    select l.*
    from tb_log l left join tb_user u on l.uid=u.id
        and u.id=#{id}
</select>
<!--用户查询角色-->
<select id="selectRole" resultMap="RoleMap">
    select r.*
    from tb_user u left join tb_user_role ur on u.id=ur.user_id
                        left join tb_role r on r.id=ur.role_id
    where u.id=#{id}
</select>
<!--角色查询菜单-->
<select id="selectMenu" resultMap="MenuMap">
    select m.*
    from tb_role r left join tb_role_menu rm on r.id=rm.role_id
                   left join tb_menu m on m.id=menu_id
    where r.id=#{id}
</select>
<!--id用户信息-->
<select id="selectU" resultMap="UserMap">
    select * from tb_user
    where id=#{id}
</select>