DROP function IF EXISTS `getChildrenOrg`;
create function getChildrenOrg(orgid INT)
returns varchar(400)
BEGIN
DECLARE oTemp VARCHAR(400);
DECLARE oTempChild VARCHAR(400);
SET oTemp = '';
SET oTempChild = CAST(orgid AS CHAR);
WHILE oTempChild IS NOT NULL
DO
SET oTemp = CONCAT(oTemp,',',oTempChild);
SELECT GROUP_CONCAT(dept_id) INTO oTempChild FROM sys_dept WHERE FIND_IN_SET(parent_id,oTempChild) > 0;
END WHILE;
RETURN oTemp;
END
相似问题