How to pass in preparedstatement query to mysql an array of values ​​in IN()?

Question

MySQL

Query example: SELECT users FROM table WHERE id IN(?)
Googling found a discussion of the problem stackoverflow.com/questions/178479/preparedstateme...
from which it becomes clear that without crutches, you simply cannot substitute an array.
The answers are dated 2-3 years ago, maybe there is a solution at the moment?
Or it remains only to generate a preparedstatement with the necessary amount of IN(?,?,?....) for each request?

Answer 1

Everything is done the same way.
And this is done in just a couple of lines.

$bind = ['somebind'];
$places = implode(', ', array_fill(0, count($bind), '?'));
$sqlpartial = " where column IN ($places) ";

Answer 2

If you really want to write a short function that will fill in the PreparedStatement, then use some libraries to work with SQL. The first thing that comes to my mind is JdbcTemplate from spring-jdbc.