Select count from three tables Laravel 5

I am building a job website and one of my challenge is like this. I have three tables: 1. location_list 2. jobpost 3. jobpost_location

Could you tell me how to list all items from location_list table like below?

JOBS BY LOCATION:

• Location 1 (89)
• Location 2 (27)
• Location 3 (0)
• Location 4 (48)
• Location 5 (0)
• Location 6 (0)
• Location N (....)

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2waasdF
via IFTTT