Kulay

select region.id, count(project.id) as total
from project
left join user on user.id = project.user_id
left join region on region.id = user.region_id
group by region.id