--子查父（通过子节点向根节点追朔.）
查询〔特下边〕的父节点
select *
from tb_class t
start with t.class_id = '1030107742'
connect by prior t.super_class_id = t.class_id
order by t.tree_level desc
--父查子（通过根节点遍历子节点.）
查询〔特下边〕的子节点：结果
select *
from tb_class t
start with t.class_id = '1030107742'
connect by prior t.class_id = t.super_class_id
order by t.tree_level desc