SELECT  time_management.id,user.name as username,time_management.description,task_date,time_management.status_change_by,
time_management.created_date,time_management.description,time_management.status,project_name,total_time_spend
FROM time_management
    JOIN project ON
    project.id = time_management.project_id
    JOIN user ON
    user.user_id=AllUsers.user_id
    JOIN (
        SELECT DISTINCT   AllUsers.user_id
        FROM (
            SELECT user_id FROM time_management
            JOIN project
            ON project.id = time_management.project_id

            WHERE project.time_approver = 'MIPL-11-002'
UNION
SELECT child_id AS user_id  FROM related_user
  WHERE related_user.parent_id = 'MIPL-11-002'
) Derived
) AllUsers
ORDER BY time_management.created_date