想要通过查询目录名,得到此目录拥有对应权限的所有用户,需要怎么做?目前的语句是这样的,但是得到的结果中 .<DISPLAYNAME>这个字段好多都是空值啊SELECT *FROM . as ainner join( SELECT * FROM . )as bon a.id=b.useridleft join( SELECT * FROM . )as con b.roleid=c.roleidleft join( SELECT * FROM . )as don c.AUTHORITYENTITYID=d.idorder by USERNAME