SELECT film.id, film.name, film.descrioption,
actor.id actor_id, actor.name actor_name,
genre.id genre_id, genre.name genre_name
FROM films
LEFT JOIN films_genres ON film.id = films_genres.film_id
LEFT JOIN genre ON genre.id = films_genres.genre_id
LEFT JOIN films_actors ON film.id = films_actors.film_id
LEFT JOIN actor ON actor.id = films_actors.actor_id
WHERE films_actors.actor_id IN (734, 44) -- актеры такие-то
AND films_genres.genre_id = 3 -- жанр такой-то