SELECT m.movie_id, m.name, s.scene_id, p.performer_id
FROM movies m
LEFT JOIN scenes s USING (movie_id)
LEFT JOIN scenes_performers sp USING (scene_id)
LEFT JOIN performers p USING (performer_id)
ORDER BY movie_id ASC, scene_id ASC