mysql 查询所有父子节点

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