问nodejs mysql查询只显示一条记录，而不是数据库中的所有记录

EN

var connection = require('./config');
module.exports.getpost = function (req, res) {
   connection.query('SELECT * FROM posts', function (error, results, fields) {

        if (error) {
            console.log('error');
            res.json({
                status : false,
                message : 'there are some error with the query'

            });
        } else {
            var postid = results[0].id;
            var title = results[0].title;
            var content = results[0].content;
            var type = -1;
             console.log(title);

        // Checking user status
   connection.query('SELECT count(*) as cntStatus,type FROM like_table WHERE userid= ? and postid=?', [userid,postid], function (error, results, fields) {
         if (error) {
                    console.log('error');
                    res.json({
                        status : false,
                        message : 'there are some error with the query'

                    });
                } else {



                    var total_count = results[0].cntStatus;
 if(total_count > 0){
        type = results[0].type;

        }



                    var total_count = results[0].cntStatus;
                    var result = {



                        "id" : postid,
                        "title" : title,
                        "content" : content,
"type" : type,
"likes" : total_count
                    };

                    console.log('query okay');
                    res.json({
                        //data:results,
                        data : result

                    });
                }
            });
        }

    });
}