Retrieve the total of the users for each countries

[graphic]

I want write by an function the total of the users for the regions in this mode for example:

['Country', 'Total of users'],
['Germany', 200],
['United States', 300],
['Brazil', 400],
['Canada', 500],
['France', 600],
['RU', 700]

There is a possibility to retrieve the total of the users registered divided for countries from mysql data? Thanks for assistance