oracle 根据子节点生成树

参考SQL语句：

 

select  *  from menu 

start with id in (select menu_id from role_menu 

where role_id in (select role_id from user_role where user_id = '201503010936055450')

group by menu_id) 

connect by prior parent_id =  prior id

order by display_order