对应两张表,另外一张表有parentId字段,拼接成一棵树
select * from (
SELECT t1.id ,t1.name as name ,parent_id
FROM SAF_FUND_TYPE t1
union all
select -1 as id,t2.name as name,t2.fund_type_id as parent_id
from saf_fund_account t2) t
START WITH parent_id=0 --第一级的parent_id = 0
CONNECT BY PRIOR t.id= t.parent_id; ----前面一条数据的ID=后面数据的parent_id