mysql查询子类查询所有上级父类

SELECT T2.*
FROM ( 
        SELECT 
                @r AS _id, 
                (SELECT @r := p_id FROM mami_goods_category WHERE c_id = _id) AS parent_id, 
                @l := @l + 1 AS lvl 
        FROM 
                (SELECT @r := 6, @l := 0) vars,
                mami_goods_category h 
        WHERE @r <> 0) T1 
JOIN mami_goods_category T2 
ON T1._id = T2.c_id 
ORDER BY T1.lvl DESC

 下面截图是替换自己数据库的方法

数据库数据

运行sql结果

父类查询子类 点进去查看