How to select from VALUES in mysql
MySQL (as well as Postgres) allows you to select from nothing, so you can do this:

select * 
from (
  select 1 as some_value
  union all
  select 2
  -- etc.
) t


Since you intend to join this set to a table, you'll need to provide column aliases that you can reference later at least in the first inner select.