Express JS fetch proper JSON with Mysql

I am working on WebAPI on ExpressJS. I am fetching data from MySQL database by using node module mysql. I have a mater and a detail table let say

Countries(ID, Name, Code)

States (ID, Name, CountryId)

Now I want to query the data in JSON as following:

{
  "country":{
              "ID" : 1,
              "Name" : "United States of America"
              "Code" : "USA"
              "Cities" : 
              [
               {
                "1",
                "Alabama",
                "AL"
               },
               {
                "2",
                "Alaska",
                "AK"
               },
               {
                "3",
                "California",
                "CA"
               }
              ]
            }
}

How can I query data in the above format? Thanks and Regards.

via Abdullah Feroz