多张关联表,均以id为关联,要返回前台能 处理的tree数据,看了网上的,很多是采用一对多查询方式,比较麻烦,后台返给前台一般是id name pid 格式,突然想到,是不是可以将关联表进行联合就行了,实验了下,确实,如此
SELECT p.id as id ,p.name as name,-1 as pid FROM p
UNION
SELECT s.id+3 as id,s.name as name,s.p_id as pid FROM s
UNION
SELECT d.id+9 as id,d.name as name,d.s_id+3 as pid FROM d
ORDER BY id
;
有多少张表都可以,无非就是传参而已。
关联表联合成适合tree树形数据表
最新推荐文章于 2022-11-25 17:05:55 发布