How to display the menu from the database?

Question

MySQL

Good morning. Please help. I've been warming my head for several hours, I don't understand how to display the menu.
I have such a script at the moment, it finds all matching sub-items and displays them in arrays. Later I need to display text under these id
parent_id - id of sub -items
id - id of items
title - text of items

connection.query("SELECT * FROM menu", function(err,res){
    const menu = res.map(list => list)

    for(i=0; i<menu.length; i++) {
      connection.query("SELECT * FROM menu WHERE parent_id = '"+menu[i].id+"'", function(err,res){
        
      })
    }

  })

Answer 1

connection.query('SELECT * FROM menu', (err, result) => {
  if(err) {
    console.error(err);
    return;
  }
  const index = result.reduce((acc, row) => ({...acc, [row.id]: row}), {});
  const menu = [];
  for(const row of result) {
    if(row.parent_id === 0) {
      menu.push(row);
      continue;
    }
    const parent = index[row.parent_id];
    if(!parent) {
      console.warn(`Undefined parent with id ${row.parent_id}`);
      continue;
    }
    if(!parent.children) {
      parent.children = [];
    }
    parent.children.push(row);
  }
  console.log(menu);
});