SELECT
T1.id AS taskId,
T1.relay_person_name AS relayPersonName,
T1.father_task_id AS fatherTaskId,
T1.task_state AS taskState
FROM
task_info T1
INNER JOIN (
SELECt
@id AS _id,
( SELECT @id := father_task_id FROM task_info WHERe id = _id ) AS father_task_id,
@sort := @sort + 1 AS sort
FROM
( SELECt @id := #{taskId}, @sort := 0 ) T2_1,
task_info T2_2
WHERe
@id IS NOT NULL
AND @id != ''
) T2 ON T1.id = T2._id
ORDER BY
T2.sort DESC;