SELECT T.Menu_Id,--子id
T.Menu_Parent_Id,--父id
lpad(' ',6*(level-1))||t.menu_name AS menu_name,--菜单项名称
LEVEL,--当前菜单所在树形节点级别
t.menu_url--当前菜单的url
FROM uum_menu T
START WITH t.Menu_Id='0' --表示从哪级节点开始
CONNECT BY PRIOR T.Menu_Id = T.Menu_Parent_Id;