SQL Select to JSON for Menu Structure

I was looking for help with a query which will produce the output in JSON that I could use to populate a Menu, thus the JSON needs to create the menu structure. Here are the two tables that I have,...