select ID from 表名start with id =节点id connect by prior parentid = id 其中id为表中id标识,parentid为父节点id标识 转载于:https://www.cnblogs.com/Hawk-cyc/p/9177690.html