oracle按层级分组,求sql多层级排序问题

with t as (

select '74516ecfc66c4bd6a0790ed99cad5378' spfl_id,'文具办公' spfl_name,'' spfl_parent_id,'10' spfl_order from dual union all

select '9855f9d191b2402a973a4fd1b8196cdd' spfl_id,'12' spfl_name,'06' spfl_parent_id,'12' spfl_order from dual union all

select '01' spfl_id,'家电数码' spfl_name,'' spfl_parent_id,'2' spfl_order from dual union all

select '02' spfl_id,'食品酒类' spfl_name,'' spfl_parent_id,'3' spfl_order from dual union all

select '03' spfl_id,'服装鞋帽' spfl_name,'' spfl_parent_id,'5' spfl_order from dual union all

select '04' spfl_id,'居家百货' spfl_name,'' spfl_parent_id,'6' spfl_order from dual union all

select '05' spfl_id,'母婴玩具' spfl_name,'' spfl_parent_id,'7' spfl_order from dual union all

select '06' spfl_id,'农资农具' spfl_name,'' spfl_parent_id,'8' spfl_order from dual union all

select '07' spfl_id,'本地生活' spfl_name,'' spfl_parent_id,'1' spfl_order from dual union all

select '08' spfl_id,'保健用品' spfl_name,'' spfl_parent_id,'9' spfl_order from dual union all

select '124e8454951249b7af147d5f9b8275c3' spfl_id,'12' spfl_name,'06' spfl_parent_id,'12' spfl_order from dual union all

select 'ae342e25ec984c7c86f48036b2e7b1d6' spfl_id,'本地购物' spfl_name,'07' spfl_parent_id,'1' spfl_order from dual union all

select 'adca694f707c46f4a2006264105ea17b' spfl_id,'男装' spfl_name,'03' spfl_parent_id,'2' spfl_order from dual union all

select '47c773551050410f924ece98dbab25fe' spfl_id,'童装' spfl_name,'03' spfl_parent_id,'3' spfl_order from dual union all

select '985ebc290d3a49cf8f745b872b3a0e54' spfl_id,'女装' spfl_name,'03' spfl_parent_id,'1' spfl_order from dual union all

select '09' spfl_id,'金猴皮鞋专场' spfl_name,'' spfl_parent_id,'0.5' spfl_order from dual

) select * from t