Oracle树结构查询按层级排序

sql代码：

select t.*
from pt_org_info t
start with t.id = 1
connect by t.par_id = prior t.id
order siblings by t.id;

view code

 效果图：