如何从数据库查询(PHP)向多个收件人发送电子邮件

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询收件人的电子邮件地址
$sql = "SELECT email FROM recipients";
$result = $conn->query($sql);

// 使用 PHPMailer 发送电子邮件
require 'vendor/autoload.php';
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

$mail = new PHPMailer(true);

try {
    // 邮件服务器设置
    $mail->SMTPDebug = 2;
    $mail->isSMTP();
    $mail->Host = 'smtp.example.com';
    $mail->SMTPAuth = true;
    $mail->Username = 'username';
    $mail->Password = 'password';
    $mail->SMTPSecure = 'tls';
    $mail->Port = 587;

    // 邮件内容设置
    $mail->setFrom('sender@example.com', 'Sender Name');
    $mail->isHTML(true);
    $mail->Subject = '邮件主题';
    $mail->Body = '邮件正文内容';

    // 向所有收件人发送邮件
    while($row = $result->fetch_assoc()) {
        $mail->addAddress($row["email"]);
    }

    $mail->send();
    echo '邮件已成功发送';
} catch (Exception $e) {
    echo "邮件发送失败: {$mail->ErrorInfo}";
}

// 关闭数据库连接
$conn->close();
?>