How to get object from pool.query query (Node Js, PostgreSQL)?

Question

Node.js

You need to get an object for further use.
First I tried to do this:

const getUsers = async () => {
    await pool.query('select * from users', (err, result) => {
        if (err) {
            console.log(err);
        }
        return result.rows;
    });
}
const data = getUsers();
console.log(data);

But at the output I got Promise { pending }.
Added .then() to fix the bug:

let data = [];
getUsers().then((result) => {
    data = result;
    console.log(data);
});

But the output is undefined.

Answer 1

const getUsers = async () => {
    let real_result = await pool.query('select * from users', (err, result) => {
        if (err) {
            console.log(err);
        }
        return result.rows;
    });
  return real_result;
}

let data = [];
getUsers().then((result) => {
    data = result;
    console.log(data);
});