How to get a variable with query result outside query?

Question

MySQL

Good night. Please tell me how to get a variable with the result of this request outside the request?

app.get('/viewmenu', (req,res) => {

    connection.query('SELECT * FROM menu', (err, result) => {
        if(err) {
          console.error(err);
          return;
        }
        const index = result.reduce((acc, row) => ({...acc, [row.id]: row}), {});
        var 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);
          
          
        }
    });

               // Здесь получить нужно

    res.send(123)

})

Answer 1

Seriously?
This is a promise .