mysql 5.7查找递归树下的所有子任务

select * from  (SELECT
    team_task_temp.* 
FROM
    ( SELECT * FROM team_task where project_code = '27fd72c62140416a8b1aa49145e27c5f' ) team_task_temp,
    ( SELECT @pv := '825a43a940664a54b4bf20278b5e8952' ) initialisation 
WHERE
    find_in_set( pcode, @pv ) 
    AND length(
    @pv := concat( @pv, ',', CODE ))
    union 
    SELECT * FROM team_task  where code = '825a43a940664a54b4bf20278b5e8952'
    ) a
    where a.begin_time='2022-04-11'