PHPを使用してグループでメールを送信する方法

$groups = [
    'group1' => ['a@example.com', 'b@example.com', 'c@example.com'],
    'group2' => ['d@example.com', 'e@example.com', 'f@example.com'],
    ...
];

CREATE TABLE `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `members` text NOT NULL,
  PRIMARY KEY (`id`)
);

<?php
require 'phpmailer/PHPMailerAutoload.php';

// 数据库连接信息
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'dbname';

// 连接数据库
$conn = mysqli_connect($host, $user, $pass, $dbname);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// 查询分组信息
$sql = "SELECT * FROM groups";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        // 分组成员
        $members = explode(',', $row['members']);

        // 发送邮件
        $mail = new PHPMailer;
        $mail->isSMTP();
        $mail->Host = 'smtp.example.com';
        $mail->SMTPAuth = true;
        $mail->Username = 'username';
        $mail->Password = 'password';
        $mail->setFrom('from@example.com', 'from');
        foreach ($members as $member) {
            $mail->addAddress($member);
        }
        $mail->Subject = 'subject';
        $mail->Body = 'body';
        if (!$mail->send()) {
            echo 'Mailer Error: ' . $mail->ErrorInfo;
        } else {
            echo 'Message sent!';
        }
    }
}

mysqli_close($conn);