Hi. I am using Yii2 basic. I have a master table called District which stores DistrictId and District name. There is another table called groupdetails which stores the group details for any district. So DistrictId is the foreign key in groupdetails. Now there are records for group details for District Ahmednagar and Aurangabad. Following is the query.
select district.District, count(*) as Groups
from groupdetails, district
where groupdetails.DistrictId = district.DistrictId
group by groupdetails.DistrictId
Now the requirement is that I want to use this query in order to display a google map which showing markers for Ahmednagar and Aurangabad and display total number of groups for each district. How to accomplish this in yii2. Are there any extension for doing or can we do it by storing latitude and longitude.