Ggtcf

I'm trying to create an api route using Node and Express and I must say I don't have much experience with it. Right know I have the following code:

app.get('/api/place/:id', (req, res) => 
var id = req.params.id;
var message_error = '"status": "failed", "message": "Unable to fetch data"';

db.query("SELECT `id`, `user`, `lat`, `lon`, `elevation`, `rating`, `rating_count`, `country`, `continent`, `locality` FROM `t_points` WHERE id = ?", [id], (err, res1) => 
 if(err) 
 res.json(message_error);
 else 
 //Store the user id from the points table and use it to fetch user datas
 var userId = res1[0].user;
 if(userId != null) 
 db.query("SELECT `id`, `name` FROM `t_users` WHERE `id` = ?", [userId], (err, res2) => 
 if(err) 
 res.json(message_error);
 else 
 //Final json structure
 res.json(
 id: res1[0].id,
 lat: res1[0].lat,
 lon: res1[0].lon,
 elevation: res1[0].elevation,
 rating: res1[0].rating,
 rating_count: res1[0].rating_count,
 user: 
 id: res2[0].id,
 name: res2[0].name
 
 );
 
 );
 else 
 res.json(
 id: res1[0].id,
 lat: res1[0].lat,
 lon: res1[0].lon,
 elevation: res1[0].elevation,
 rating: res1[0].rating,
 rating_count: res1[0].rating_count
 );
 
 
 );
);

I'm hard-coding the json structure so if the userId in my table is null I don't print the user object in the json, otherwise I print it. But that's not a good idea, as I will also add more queries in the same route. Is there a simple way to create just one json at the end of all the queries and if some values are null not showing it?

Also, would it be better to use async and await functions to do it, instead of this way?

Thanks!