查询父子树 select c_channelno from tchanneltree tc start with c_channelno='000100020041' connect by prior c_channelno = tc.c_parentcode