SELECT piv.id as pivot_id,p.nama as project_name,p.tanggal as project_tanggal,p.biaya as project,c.nama as category_name FROM pivot_category 
LEFT JOIN project p ON piv.project_id = p.id
LEFT JOIN category c ON c.category_id = c.id