MySQL函数 查询树子节点

DELIMITER $$
CREATE FUNCTION getChildList (rootId VARCHAR(50)) RETURNS varchar(1000)
BEGIN
DECLARE sChildList VARCHAR(1000);

DECLARE sChildTemp VARCHAR(1000);

SET sChildTemp =cast(rootId as CHAR);

WHILE sChildTemp is not null DO

IF (sChildList is not null) THEN

SET sChildList = concat(sChildList,'@',sChildTemp);

ELSE

SET sChildList = concat (sChildTemp);

END IF;

SELECT group_concat(bop_object_id) INTO sChildTemp FROM base_bs_recycle_oldpath where FIND_IN_SET(bop_fol_id,sChildTemp)>0;

END WHILE;

RETURN sChildList;

END;