Why not do something like this:

  while ($user_hashref = $sth->fetchrow_hashref) {
     print "name = $user_hashref->{username}\n";
     print "email = $user_hashref->{email}\n";
  }
[download]

The hashref that fetchrow_hashref gives you back doesn't necessarily need to be turned back into another hash to be used - you can use the hashref($user_hashref above) to point at individual element values using the greater than(->) notation.

HTH.