my @userArray = qw(batman robin joker);
my $set = join(",", map { $dbh->quote($_) } @userArray);
my $sql = "select * from tablename where username IN ($set)";
# ...