select * from pmt_module t start with t.parent_id='1142001001' connect by prior t.module_id=t.parent_id;