mysql查询部门及所有子集部门

DROP FUNCTION IF EXISTS getChilds;
CREATE FUNCTION getChilds( dpId BigInt ) RETURNS varchar(1000)
BEGIN
DECLARE ptemp varchar(1000)
DECLARE ctemp varchar(1000)
SET ptemp = “”;
SET ctemp = CAST( dpId AS CHAR);
WHILE ctemp is not null DO
set ptrmp = CONCAT( temp,",",ctemp);
SELECT GROUP_CONCAT( deId) INTO ctemp FROM zc_department WHERE find_in_set( dpId,ctemp) > 0
END WHILE
RETURN ptemp
END