//查找所有分类及其父类 SELECT s.type_id,        s.type_name,        p.type_name   FROM 表1 AS s   LEFT JOIN 表2 AS p ON s.parent_id= p.type_id;