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

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));