select * from cascade start with id = 1 connect by PRior id = sjcd_id  order by id;start with id = 1 --代表從哪里開始遞歸查詢，包括自己。connect by prior id = sjcd_id --代表使用 sjcd_id 和 id 進行遞歸匹配。