mysql 查询所有父子节点
查询父节点 (包含查询节点)
SELECT t.id FROM(SELECT
@id idlist,
(SELECT @id := GROUP_CONCAT(parent_id SEPARATOR ',') FROM wo_building_info WHERE FIND_IN_SET( id, @id)) sub
FROM wo_building_info,(SELECT @id := 5) a
WHERE @id IS NOT NULL) tl,
wo_building_info t
WHERE
FIND_IN_SET(t.id, tl.idlist);
查询子节点
select id from (
select t1.id,t1.parent_id,
if(find_in_set(parent_id, @pids) > 0, @pids := concat(@pids, ',', id), 0) as ischild
from (
select id,parent_id from energy_category t where t.deleted = '0' order by parent_id, id
) t1,(select @pids := 4) t2
) t3 where ischild != 0