Query in multiple Node + Mysql tables

Question

Taking into account the need to bring the result of a second table, based on the result of the first, how would you do this with Nodejs ? In PHP I would bring the result, and inside a while did another query by passing the ID of the first query (I know that is not the best practice).

//List users

router.get("/users", (req, res) => {
    let query = "SELECT * FROM ??";
    let table = ["users"];
    query = mysql.format(query, table);
    connection.query(query, (err, rows) => {
        if(err){
            res.json({"Error": true, "Message": "Erro ao executar query do Mysql"});
        }else{
            res.json({"Error": false, "Message": "Successo", "Users": rows});
        }
    });
});

List information from the user

let query = "SELECT * FROM ?? WHERE ?? = ?";
let table = ["users_info"];
query = mysql.format(query, table);

It would be in the case of these two, list the user and list his information in another table.

Answer 1

You can do this in a single select where you join the two tables. If I understand correctly sexo, nascimento, descricao table users_info, then a select set would be like this:

SELECT ui.sexo, ui.nascimento, ui.descricao, u.id 
FROM users AS u
LEFT JOIN users_info AS ui ON u.id = ui.id_user
WHERE u.id=??

And the columns that this select gives will be sexo, nascimento, descricao table users_info, and id table users.