sub sa_details {
  my $dbh = ...

  return $dbh->selectcol_arrayref(
    qq{SELECT userid FROM user}
  );
}

my $arrayref = sa_details();