How best can I write this query?

Question

I am currently working on an Online Food Ordering App where Many restaurants offer different menu that belongs to a particular MenuCategory. which means that I have

restaurant

menu(contains a foreign key to the MenuCategory)

menucategory,

restaurant_menu(contains foreign keys to menu and restaurant). 

Now I want to fetch all the menu for each restaurant by categories so that I can display them using nested repeater control. I have been able to display the categories of menu offered by each restaurant.

How can I fetch the menu details for each category for a particular restaurant using ADO.NET technology. The ER diagram is shown in the image below:

and the expected output should be similar to the one found here:

http://www.c-sharpcorner.com/UploadFile/rohatash/showing-category-and-subcategory-using-nested-repeater-in-as/