mysql查询某分类所有下级分类

##根据分类id查询所有子级id
WITH RECURSIVE category_hierarchy AS (
	SELECT
		id,
		pid,
		NAME,
		CODE,
		NAME AS fullName 
	FROM
		cms_catalog 
	WHERE
		delete_status = 0 
		AND id = '1810877998655524866' UNION ALL
	SELECT
		c.id,
		c.pid,
		c.NAME,
		c.CODE,
		CONCAT( ch.fullName, ' > ', c.NAME ) AS fullName 
	FROM
		cms_catalog c
		INNER JOIN category_hierarchy ch ON c.pid = ch.id 
	WHERE
		c.delete_status = 0 
	) SELECT
	* 
FROM
	category_hierarchy;

结果示例：