想要通过查询目录名，得到此目录拥有对应权限的所有用户，需要怎么做？

目前的语句是这样的，但是得到的结果中[FINE_AUTHORITY_OBJECT] .<DISPLAYNAME>这个字段好多都是空值啊

SELECT *

FROM [dbo].[fine_user] as a

inner join(

SELECT * 

FROM [dbo].[FINE_USER_ROLE_MIDDLE] 

)as b

on a.id=b.userid

left join(

SELECT * 

FROM [dbo].[FINE_AUTHORITY] 

)as c

on b.roleid=c.roleid

left join(

SELECT * 

FROM [dbo].[FINE_AUTHORITY_OBJECT] 

)as d

on c.AUTHORITYENTITYID=d.id

order by USERNAME