The database function to retrieve a JSON response as
{
"menus": [
{
"menu_id": 1,
"menu_name": "Main Menu 1",
"menu_description": "This is the description for Main Menu 1.",
"display_order": 1,
"parent": null,
"submenus": [
{
"menu_name": "Submenu 1-1",
"menu_description": "This is the description for Submenu 1-1.",
"display_order": 1,
"menu_url": "",
"parent": 1,
"submenus": [
{
"menu_name": "Submenu 1-1-1",
"menu_description": "This is the description for Submenu 1-1-1.",
"display_order": 1,
"menu_url": "",
"parent": 1
},
{
"menu_name": "Submenu 1-1-2",
"menu_description": "This is the description for Submenu 1-1-2.",
"display_order": 2,
"menu_url": "",
"parent": 1
}
]
},
{
"menu_name": "Submenu 1-2",
"menu_description": "This is the description for Submenu 1-2.",
"display_order": 2,
"menu_url": "",
"parent": 1
}
]
},
{
"menu_id": 2,
"menu_name": "Main Menu 2",
"menu_description": "This is the description for Main Menu 2.",
"display_order": 2,
"parent": null,
"submenus": [
{
"menu_name": "Submenu 2-1",
"menu_description": "This is the description for Submenu 2-1.",
"display_order": 1,
"menu_url": "",
"parent": 2
},
{
"menu_name": "Submenu 2-2",
"menu_description": "This is the description for Submenu 2-2.",
"display_order": 2,
"menu_url": "",
"parent": 2,
"submenus": [
{
"menu_name": "Submenu 2-2-1",
"menu_description": "This is the description for Submenu 2-2-1.",
"display_order": 1,
"menu_url": "",
"parent": 2
},
{
"menu_name": "Submenu 2-2-2",
"menu_description": "This is the description for Submenu 2-2-2.",
"display_order": 2,
"menu_url": "",
"parent": 2
}
]
},
{
"menu_name": "Submenu 2-3",
"menu_description": "This is the description for Submenu 2-3.",
"display_order": 3,
"menu_url": "",
"parent": 2
}
]
}
]
}