SELECT
    projects.project_id,
    projects.project_name,
    projects.description,
    projects.progress,
    projects.live_flag,
    projects.clientid,
    projects.project_id,
    IFNULL(SUM(tasks.task_hours),0) AS project_hours,
    IFNULL(FORMAT(SUM(tasks.fee),2),0) AS project_fee
    

FROM

    projects LEFT JOIN tasks ON projects.project_id = tasks.project_id
    
##client_id##
     
GROUP BY
    projects.project_id DESC