查询当前用户下所有的子用户

BEGIN    DECLARE sUser VARCHAR(4000);    DECLARE sUserChd VARCHAR(4000);    SET sUser = '$';    SET sUserChd = cast(userID as char);    WHILE sUserChd is not NULL DO        SET sUser = CONCAT(sUser ,',',sUserChd );        SELECT group_concat(id) INTO sUserChd FROM             t_sys_user where FIND_IN_SET(parentId,sUserChd )>0;    END WHILE;    return SUBSTR(sUser,3);END

SELECT  *  FROM t_sys_user  WHERE id = 75 OR  FIND_IN_SET(parentId,fn_getAllUserChild(75));