Need postgres statement that returns non unique records even if I pass same ids in array
Join against the array:

select tt.*
from tennis_ticket tt
  join unnest(array[3,3]) x(id) on x.id = tt.id;


or use a values clause

select tt.*
from tennis_ticket tt
  join (values (3), (3)) as x(id) on x.id = tt.id;