import emails from wp comments

import.php

<?php
 
$db = new mysqli('host', 'user', 'pass', 'bd');
 
$sql = "SELECT comment_author_email, comment_author
    FROM  `wp_comments` 
	WHERE comment_author_email <>  ''
	GROUP BY comment_author_email
	ORDER BY (
		comment_author_email
	)";
 
$query = $db->query( $sql );
while( $dados = $query->fetch_object() ){
	$arr[] = "\"{$dados->comment_author}\", \"{$dados->comment_author_email}\"";
}
 
echo implode($arr, "\n");

?>

query.sql

SELECT comment_author_email, comment_author
FROM  `wp_comments` 
WHERE comment_author_email <>  ''
GROUP BY comment_author_email
ORDER BY (
comment_author_email
INTO OUTFILE '/tmp/meuarquivo.csv'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n';