How to convert an array received from mysql to another form?

Question

MySQL

Code (node.js):

var mysql      = require('mysql');

var connection = mysql.createConnection({
  host     : '*********',
  user     : '*********',
  password : '**********',
  database : '**********'
});

module.exports = (arg, callback) => {
  
connection.connect();

connection.query('SELECT user FROM users', function(err, rows, fields) {
  if (err) throw err;

  return callback('Текст: ' + JSON.stringify(rows));
});

connection.end();
        
}

I get: Text: [{"user":317959591},{"user":222222},{"user":3333333}]
How to make the array look like: ['317959591', '222222', '3333333']

Answer 1

Something like this.
if (err) throw err;
var array = new Array();
for (var t in rows)
array.push(t['user']);
return callback('Text: ' + JSON.stringify(array));

Answer 2

var mysqlText = '[{"user":317959591},{"user":222222},{"user":3333333}]';
var mysqlArray = JSON.parse(mysqlText);
var array = mysqlArray.map(function(i){ return i.user });
console log(array);
// [317959591, 222222, 3333333]

Answer 3

...
connection.query('SELECT user FROM users', function(err, rows, fields) {
  if (err) throw err;
  return callback('Текст: ' + rows.map(function(row) { return row.user }));
});
...