select a.displayName as 一级目录名,

b.displayNameas 二级目录名,

c.displayNameas 三级目录名,

d.displayNameas 四级目录名

from fine_authority_object a

left join fine_authority_object  b

on a.id=b.parentId

left join fine_authority_object  c

on b.id=c.parentId

left join fine_authority_object  d

on c.id=d.parentId

where a.parentid='decision-directory-root'

order by a.displayName,b.displayName,c.displayName,d.displayName

这个order by  的顺序怎么写的  , 和系统的对不上顺序.