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.id=AllUsers.user_id
    JOIN (
        SELECT DISTINCT user_id
        FROM (
            SELECT user_id FROM time_management
            JOIN project
            ON project.id = time_management.project_id
            JOIN user
            ON  time_management.user_id = user.user_id
            WHERE project.time_approver = '$user_id'
UNION
SELECT user_id FROM elated_user
               JOIN time_management
                ON time_management.user_id = related_user.child_id
               JOIN user
               ON  'time_management.user_id = user.user_id'
               JOIN project
               ON project.id = time_management.project_id
               WHERE related_user.parent_id = '$user_id'
) Derived
) AllUsers
ORDER BY