while ( my $ref = $self->fetch_assoc($sth) )
####
my $dbh = DBI->connect(@db_args);
my $sql = "SELECT email FROM database.table";
my $sth = $dbh->prepare($sql);
$sth->execute();
while (my $hashref = $sth->fetchrow_hashref) {
...
####
my $sth = $db->query($sql)...