數(shù)據(jù)庫查詢

function query(sql) {
    return new promise((resolve, reject) => {
        pool.getConnection(function (err, conn) {
            if (err) {
                reject(err);
            } else {
                conn.query(sql, function (err, rows, cols) {
                    if (err) {
                        conn.release();
                        reject(err)
                    } else {
                        //釋放連接
                        conn.release();
                        //事件驅(qū)動(dòng)回調(diào)
                        resolve({ rows: rows, cols: cols });
                    }
                });
            }
        });
    });
};

exports.myTickets = (userId, cb) => {
    let sql = util.format('select ticketId,number from ticket_Numbers where userId="%s"', userId);
    db.query(sql)
        .then((data) => {
            let tickets = data.rows;
            tickets.map(ticket => {
                db.query(util.format('select userId,number from ticket_numbers where ticketId="%s"', ticket.ticketId))
                    .then((players) => {
                        ticket.players = players.rows;
                    });
            })
            console.log(tickets);    //這里log出來有players
            console.log(JSON.stringify(tickets));    //stringify之后 players丟失
            cb({ success: true, tickets: tickets });
        })
        .catch(err => {
            console.log(err.stack);
            cb({ success: false, message: err.message });
        });
}

結(jié)果：

node新手，請(qǐng)教為什么會(huì)這樣，哪里寫錯(cuò)了？