oracle的树
select *
from t_area t
start with t.id = 100
connect by prior t.id = t.parent_id
select *
from t_area t
start with t.id = 100
connect by prior t.id = t.parent_id