my $sql = 'select 1 from subscription where user_id = ?';
my $sth = $dbh->prepare($sql);
foreach my $userid ... {
 $sth->execute($userid);
 my ($exists) = $sth->fetchrow_array;
 $sth->finish;
 if ($exists) {
  ...
 }
}