# loop through rows
while ($hashref = $sth->fetchrow_hashref()) {
   push @$myarrayref , { %$hashref };
}