根据父节点查询出所有的子节点

select t.*
   from TB_BIZBASE_FUNCTION t
    start with t.id = 10686338961
    connect by nocycle prior t.id = t.parent_code
原文地址:https://www.cnblogs.com/lowerCaseK/p/parentNode_sonNode.html