Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

pasanmherath's avatar

join 3 or more tables with laravel relationship

my tables are

(vod_movie --> id ) (genry --> id ) ( vod_movie_genry --> vod_movie_id, genry_id ) ( cus_package_movie --> id, vod_movie_id )

I need to write a query as SELECT vg.genre_title,m.movie_title FROM vod_movie_genre vg LEFT JOIN vod_movie_genre_summeries s ON vg.id=s.vod_movie_genre_id LEFT JOIN vod_movie m ON s.vod_movie_id=m.id LEFT JOIN cus_packages_movies pm ON m.id=pm.movie_id WHERE pm.customer_package_id='323' AND pm.subscription_period_id='9' ORDER BY m.id

using laravel relationships. I'm ok with query builder.

0 likes
0 replies

Please or to participate in this conversation.