select * from table t start with t.id=:id connect by prior t.id=t.parentId;//从对应id开始查,包括本节点和所以子节点
select * from table t start with t.parentId=:pareanId connect by prior t.id=t.parentId;//从对应id开始查,包括本节点parentId匹配开始和所以子节点
select * from table t start with t.name=:name connect by prior t.id=t.parentId;//从对应id开始查,包括本节点name为匹配开始和所以子节点