select * from 表明 where 1=1 start with 父id=0 connect by 父id=prior 子id order by 要排序字段
select * from PUB_SUB_MENU where 1=1 start with parent_id=0 connect by parent_id=prior sub_menu_id order by seunum
select * from 表明 where 1=1 start with 父id=0 connect by 父id=prior 子id order by 要排序字段
select * from PUB_SUB_MENU where 1=1 start with parent_id=0 connect by parent_id=prior sub_menu_id order by seunum