存储过程递归查询

DROP FUNCTION IF EXISTS myFunction;
CREATE FUNCTION myFunction (rootId INT)
RETURNS varchar(1000) 
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '';
SET sTempChd =cast(rootId as CHAR);
WHILE sTempChd >1 DO
    IF sTemp = ''  
    THEN  
        SET sTemp = concat(sTemp,sTempChd);  
    ELSEIF sTemp <>''  
    THEN  
       SET sTemp = concat(sTemp,',',sTempChd);  
    END IF;

SELECT group_concat(id) INTO sTempChd FROM  kkp_panel_page  where FIND_IN_SET(aid,sTempChd)>0;
 	
END WHILE;

RETURN sTemp ;  
END