如何使用储存在数据库中的特定用户的电子邮件地址将邮件发送给该用户？

const mysql = require('mysql');
const nodemailer = require('nodemailer');

// 连接数据库
const connection = mysql.createConnection({
  host: '数据库主机名',
  user: '数据库用户名',
  password: '数据库密码',
  database: '数据库名'
});

// 查询特定用户的电子邮件地址
const userId = '特定用户标识';
const query = `SELECT email FROM users WHERE id = ${userId}`;

connection.connect();
connection.query(query, (error, results) => {
  if (error) throw error;

  if (results.length > 0) {
    const userEmail = results[0].email;
    // 构建邮件内容
    const mailOptions = {
      from: '发件人邮箱地址',
      to: userEmail,
      subject: '邮件主题',
      text: '邮件正文'
    };

    // 发送电子邮件
    const transporter = nodemailer.createTransport({
      service: '邮件服务提供商', // 如腾讯企业邮、网易邮箱等
      auth: {
        user: '发件人邮箱地址',
        pass: '发件人邮箱密码'
      }
    });

    transporter.sendMail(mailOptions, (error, info) => {
      if (error) throw error;

      console.log('邮件发送成功：' + info.response);
    });
  } else {
    console.log('未找到特定用户的电子邮件地址');
  }

  connection.end();
});