Lavacharts Eloquent Query

I need assistance with using LavaCharts, has anyone used it to get data from multiple tables?

I want to get a report showing count of cities in a particular province.

The cities table has a province_id, so I want to show a geo chart by province with number of cities in that province.

This is the raw sql query that gives me the data from db

SELECT
provinces.`name`,
Count(cities.province_id)
FROM
cities ,
provinces
WHERE
cities.province_id = provinces.id
GROUP BY
provinces.`name`

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