1.Router :

var UsersModel = require('../models/UsersModel'),
cors = require('cors');
var main = function(app){
  app.get('/api/users',function(req,res){
    UsersModel.readUsers(res);
  });
  app.post('/api/users/add',function(req,res){
    UsersModel.signup(res);
  });
};
module.exports = { controller: main };

2.Model :

var connection = require('../bin/connection');
var readUsers = function(res,position,number_page) {
    let limit;
    typeof position !== 'undefined' && typeof number_page !== 'undefined' ? limit = ' LIMIT '+position+','+number_page : limit = '';
    connection.query(" SELECT * FROM users ORDER BY id_user DESC "+limit,function(err,row,field){
        if(err) throw err;
        res.send(JSON.stringify({"status": 200, "error": null, "response": row}));
    });
};
var readUser = function(res) {
    connection.query(" SELECT * FROM users WHERE id_user = ? ",res.id,function(err,row,field){
        if(err) throw err;
        res.send(JSON.stringify({"status": 200, "error": null, "response": row}));
    });
};
var signup = function(res) {
    console.log(res);
    const data = {username: res.body.username, email: res.body.email, phone: res.body.phone, password: res.body.password, confirm_password: res.body.confirm_password}
    connection.query(" INSERT INTO users SET username = '"+res.body.username+"', email = '"+res.body.email+"', phone = '"+res.body.phone+"', password = '"+res.body.password+"', confirm_password = '"+res.body.confirm_password+"'", function(err,row,field){
        if(err) throw err;
        res.send(JSON.stringify({"status": 200, "error": null, "response": row}));
    });
};
module.exports = UsersModel = {
    readUsers: readUsers,
    signup: signup
};