mysql8 getChildren 函数实现父子查询

BEGIN
	DECLARE parentTemp TEXT(50000);
	DECLARE parentList TEXT(50000); 
	SET parentTemp =CAST(rootId AS CHAR(32));
	SET parentList ='$'; 

	 
	WHILE parentTemp IS NOT NULL DO  
		SET parentList = CONCAT(parentList,',',parentTemp); 
		SELECT group_concat(id) INTO parentTemp FROM yfw_staff where FIND_IN_SET(leaderid,parentTemp)>0  ;  
	END WHILE; 

	RETURN parentList;
END

DETERMINISTIC   //mysql8必选声明是否对数据进行修改。