my @userArray = qw(batman, robin, joker);

my $sql = "select * from tablename where username IN ?";

$stmt=$dbConn->prepare($sql);
  $stmt->bind_param(1,@userArray);
$stmt->execute();