start with 初始条件 connect by prior 父字段=子字段 查询父类目id为 970235 下面的所有子类目id select id,category_parent_id from prod_data2.category start with id = 970235 connect by prior id = category_parent_id