SQL Query Recursively Async Issue

Question

My use case demands me to call an sql recursively till no rows are returned for which I have written the below code which due to async nature doesn't work as expected.

The piece of code which does this invocation is:

let Response = await getData(userId);

async function getData(userId) {
  console.log("Invoking Get Data Function");
  let arrayOfUserId = [userId];
  let fetchMore = true,
    j = 1;
  let keyWithQoutes = -1;

  return new Promise((resolve, reject) => {
    do {
      console.log(arrayOfUserId, j)
      j++;
      if (arrayOfUserId.length > 0) {
        keyWithQoutes = arrayOfUserId.map((it) => {
          return `'${it}'`;
        });
      }
      const sql = ` Select userId from USER where reportingTo in (${arrayOfUserId})`;
      console.log(' SQL Query ', sql);
      con.query(sql, [], async(error, response) => {
        if (error) {
          fetchMore = false;
          reject(error);
        }
        console.log(
          " Response for ",
          userId,
          response,
          response.length
        );
        if (response.length == 0) {
          fetchMore = false;
          resolve(arrayOfUserId);
        }
        else {
          for (let i = 0; i < response.length; i++) {
            console.log(response[i].userId);
            arrayOfUserId.push(response[i].userId);
          }
        }
      });
    } while (fetchMore);
  });
}