MySQL遍历查询所有子节点数据

查询所有父节点下的所有子节点数据

Mysql

WITH recursive mychildren AS (
	SELECT
		id,
		parent_id,
		name,
		0 AS FLevel 
	FROM
		menu
	WHERE
		parent_id is null  
		 UNION ALL
	SELECT
		t1.id,
		t1.parent_id,
		t1.name,
		FLevel + 1 AS FLevel 
	FROM
		menu t1
		INNER JOIN mycte t2 ON t1.parent_id = t2.id 
	)
	 SELECT	b.* FROM mychildren a INNER JOIN menu b on a.id=b.id;

判断是否为父节点的条件：字段parent_id 为null