$anfrage = "SELECT userid, status FROM tabelle1 WHERE username='$username';";
&datenbank;
$ergebnisse = $sth->fetchall_arrayref( { userid => 1, status => 1 } );

foreach(@$ergebnisse)
{
   $userid = $_->{userid};
   $status = $_->{status};
}