select distinct a.username,a.realname,b.roleid,c.name ,e.parentid,e.displayname,e.pathfrom fine_user aleft join fine_user_role_middle bON a.id = b.useridleft join FINE_CUSTOM_ROLE con c.id = b.roleidleft join fine_authority dON d.roleid = b.roleidand d.AUTHORITY=2left join FINE_AUTHORITY_OBJECT eon e.id = d.authorityentityid这是我当前的sql,如果有个角色A有B目录下所有的报表查看权限,这种情况我这sql只会显示一条记录(就是角色A,然后B目录的权限一条),没法展示其目录下的所有报表,要如何修改才能实现效果。