//查找所有分类及其父类
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;
//查找所有分类及其父类
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;
转载于:https://www.cnblogs.com/dengyg200891/p/6030484.html