查询sql奉上: SELECT c.realName,c.userName,d.displayName FROM `fine_authority` a left join fine_user_role_middle b on a.roleId = b.roleId left join fine_user c on b.userId = c.id left join fine_authority_object d on a.authorityEntityId=d.id where d.expandType='102' and c.userName = '${username}' and a.authorityEntityType=0 group by c.realName,c.userName,d.displayName 来大佬帮我看看~!来大佬看一眼啊!~ |