向不同用户发送邮件，其中电子邮件地址来自 Mysql

我想从具有条件的表中获取所有行，然后向指定的用户发送电子邮件。表中有 2 个用户。如果我将 sql 语句放在 sql 语句中，则它不起作用，只有第一个用户才能收到邮件和邮件。我确信这很容易，但我是 php 和 mysql 初学者，所以请帮助我。

表中有 2 个用户。

<?php 
require'../includes/database.php'; 

    $sql = "SELECT * FROM users";  
$result = $conn->query($sql);  

if ($result->num_rows > 0) {  

    // output data of each row  
    while($row = $result->fetch_assoc()) {  
        $fname = $row["fname"];  
        $nname = $row["lname"];  
        $mailadresse = $row["email"];  
        $user2 = $fname." ".$nname;  
        echo $user2;  

        $sql = "SELECT * FROM iks_open, users WHERE Datum <= '$neudate' AND  pverantwortung = '$user2'";  
        $result = $conn->query($sql);  

        if ($result->num_rows > 0) {  
            $mailhost       = "$server";  //SMTP Host name  
            $mailsmtpauth   = true;  
            $mailusername   = "$user"; // SMTP Login  
            $mailpassword   = "$pass"; // SMTP Password  


            require_once('../includes/Mailer/class.phpmailer.php');  
            require_once('../includes/Mailer/class.smtp.php');  


            $mail = new PHPMailer();   

            $mail->IsSMTP();
            $mail->Host       = $mailhost;  
            $mail->Port       = $port;  
            $mail->SMTPDebug  = 1; // Kann man zu debug Zwecken aktivieren  
            $mail->SMTPAuth   = true;  
            $mail->Username   = $mailusername;  
            $mail->Password   = $mailpassword;  
            $mail->SMTPSecure = $sec;  


            $frommail = "$email";  
            $mail->SetFrom($frommail, 'IKS-System');  

            $address = "$mailadresse";  
            $mail->AddAddress($address);  

            $mail->Subject = "Offene IKS-Aufgaben";  
            $mail->Body = "Sie haben offene Aufgaben. Bitte einloggen und erledigen";  

            if(!$mail->Send()) {  

            $lcontact = 1;  
            } else {  
            $lcontact = 2;  

            }  

            }else {  
                echo "Alles gut";  
            }  

    }  
}  


?>