I want to extract mysql data to other function but i can't use because of that value is local varation so i find multiple query but if i using multiple query, i can't get data in field

piecoin = 100 cakecoin = 500

else if (command === "buy") {
  var query = `select piecoin from coin;`;

  database.query(query, (err, coin, field) => {
    if (err) {
      console.log(err);
    } else {
      console.log(coin[0].piecoin);
    }
  });

I can get result "100" but if i use multiple query like this

else if (command === "buy") {
  var query = `select piecoin from coin;` + `select cakecoin from coin;`;

  database.query(query, (err, coin, field) => {
    if (err) {
      console.log(err);
    } else {
      console.log(coin[0].piecoin);
    }
  });

Result is "undefined" or if i run console.log(coin[0]);

i can get [ RowDataPacket { piecoin: 100 } ] like this i want to get value in field