根据pid查询各级节点的树形结构,表结构及数据如下
调试欢乐多
我用的excel分类的,去掉了重复的
case when @rownum:=@rownum+1 =1 then t1.name else null end as name,
t1.`name`,t1.id,t1.`name`,t1.id,t1.`name`,t1.id,t1.`name`,t1.id,t1.`name`,t1.id
from
(
SELECT a.`name`,a.id,b.`name`,b.id,c.`name`,c.id,d.`name`,d.id,e.`name`,e.id
FROM b_product_category a
LEFT JOIN b_product_category b ON b.pId = a.id
LEFT JOIN b_product_category c ON c.pId = b.id
LEFT JOIN b_product_category d ON d.pId = c.id
LEFT JOIN b_product_category e ON e.pId = d.id
WHERE a.pId = 0
ORDER BY a.orderid,b.id,c.id,d.id,e.id
)t1,(select @rownum:=0) t2你试下看可以实现吗 具体为什么能实现我自己也有点蒙圈
我也再捋捋