select a.displayName as 一级目录名,b.displayNameas 二级目录名,c.displayNameas 三级目录名,d.displayNameas 四级目录名from fine_authority_object aleft join fine_authority_object bon a.id=b.parentIdleft join fine_authority_object con b.id=c.parentIdleft join fine_authority_object don c.id=d.parentIdwhere a.parentid='decision-directory-root'order by a.displayName,b.displayName,c.displayName,d.displayName这个order by 的顺序怎么写的 , 和系统的对不上顺序.