Layered twig menu with item data stored in database?

Question

PHP

Hi!
I'm making a menu for a website.
The menu element can be a link or a button with a drop-down menu, which can contain links and other menu levels.
Each element must be stored in a database table, and when the page is loaded, all elements are retrieved and a menu is formed.

Example of table entries and result...

Question: how to properly process such a menu with twig and in what form to send data to it?

Answer 1

https://twigfiddle.com/r5frag