递归,查询本级以及所有下级 select * from ( WITH RECURSIVE temp as ( SELECT t.* FROM table_name t WHERE code = :code UNION ALL SELECT t.* FROM table_name t INNER JOIN temp ON t.pcode = temp.code) SELECT * FROM temp) t;