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  time_management.user_id = user.user_id

                WHERE project.time_approver = '$user_id'

                UNION

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 related_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'