select * from organise t start with t.organiseid = #{organiseid} connect by PRIOR t.organiseid = t.parentid
#{organiseid}为要查询的当前节点ID
select * from organise t start with t.organiseid = #{organiseid} connect by PRIOR t.organiseid = t.parentid
#{organiseid}为要查询的当前节点ID