Laravel Eloquent: Deeper Relationships with One Query

If you work with a project that has multiple levels of hasMany relationships, you can use hasManyThrough instead, or one of a few packages I will show in this video.
Official docs on HasManyThrough: laravel.com/docs/8.x/eloquent...
Packages by Jonas Staudenmeir: github.com/staudenmeir
My course "Eloquent: Expert Level": laraveldaily.com/course/eloqu...
My course "Better Eloquent Performance": laraveldaily.com/course/eloqu...
- - - - -
Support the channel by checking out my products:
- My Laravel courses: laraveldaily.com/courses?mtm_...
- Laravel QuickAdminPanel: quickadminpanel.com
- Livewire Kit Components: livewirekit.com
- - - - -
Other places to follow:
- My weekly Laravel newsletter: us11.campaign-archive.com/hom...
- My personal Twitter: / povilaskorop

[@chengkangzai]

This will soon be the one of the most viewed video in this channel 😂 good work

[@muditgulgulia5350]

Correct 😂

[@aboodlibda7161]

Yes I think ❤

[@dibbyo456]

Yup

[@chengkangzai]

Yes, it's me in 8 month, revisiting this video 😂

[@0x0456]

This is EXACTLY what I needed to see. Thank you so much!

[@pankajbokdia]

I cannot thank you enough! Your channel is AMAZING! Thank you for doing what you do!

[@tiagooliveira14]

This packages should be in the framework. They're really good.

[@LaravelDaily]

Anyone can add anything to the framework, it's open-source, so you can try.

[@KgfLikia]

Ι was about to say the same.

[@philipcook6191]

Soon to by membership this month. Your way of explaining wastes no time and you to the point and so knowledgeable, been watching for year but I need to get into your full courses. Thanks for this, a super help. From cape town, south africa.

[@worthsalive]

You just earned a new subscriber. Kudos to you. You just showed me exactly what I needed to see

[@hamzaradouan4074]

I literally needed to know this, thank you so much 💓 keep up the great work 💪

[@DennisBraga]

Life saving tip. Life saving package. Congrats to both.

[@levieraf]

Dude! you are awesome, so so accurate!
You are a good teacher! I love your channel!
Great work!

[@bilaljan7659]

that is what i was searchingfor an hour, thanks alot sir !!!

[@salman-804]

I learnt a lot from this tutorial. Thanks a lot !!

[@KasimSheyi]

Your videos are always wonderful.

[@MahmodurRahmanShihab]

Thanks for your laravel daily tips.

[@jeanfrancois3605]

OMG, this is amazing thank you so much!

[@azeroth5672]

This is what I need!!! Thankyou so muchh for this

[@glowiever]

finally the addon is mature enough to use! nice tutorial.

[@JamesShisiah]

This is really great. Love it

[@shaadishtiaque2084]

Your tutorials help a lot... Thanks

[@ValeriyaPolovinkina]

Thank you for this video. In real life we need in one query some fields from first level, some from second level, third, etc. But it is another story =)

[@user-zg1pc6md6y]

Большое спасибо) смотрю каждый день. Всегда очень полезно

[@user-ld1gz1cr1j]

Реал, не сложно говорит. Прекрасно понятно

[@ARMONEY666]

Иногда такие вещи показывает что удивляешся

[@msdeav]

Really helpful video. Thank you

[@AldhiAlbadri]

Problem solving, thanks sir!

[@shahosanandaji9894]

You are the best, Povilas!

[@HadiHasanpur]

Many thanks You are best in yours job ... I cannot thank you enough! Thank you teacher for your trainings!

[@auroraapps1853]

Superb Laravel specialized developer of all the time. I like you Sir

[@vigneswarans13]

Excellent explanation 🎉

[@md.robelahammed4763]

Amazing content. It helps me a lot. Thanks

[@Matheus708]

Wow! that`s really really awesome!

[@vbadheli]

Thank you.. this help me a lot..

[@demeja16]

Очень крутое видео, спасибо за улучшение наших знаний в Laravel:)

[@maxgoose4671]

ну я хз понял ли он)

[@poplach]

Very informative video, thanks.

[@Trizen321]

you always provide good content

[@hostname47]

very very very helpful package thanks !

[@codepilot2766]

This is awesome bro......It will help me a lot :)

[@alexandergontsov6219]

Really good job. Thanks 🙏

[@MUJAHIDKHAN]

Thank sir , one of the best video

[@tarekalhalabi8776]

Great video💙

[@abdalkhalekchamkha3622]

you are the best ,thanks you for improving my laravel knowledge, i was do stupid things before i see this video 😅

[@biplobshaha2829]

Thank you so much. It's help me a lot.💝💝

[@user-rm4zo1mg5o]

Something done with few lines I have to do with complex sql queries with joins, to do the same on old projects running over laravel 5.2 in my main work. Thank for this video.

[@g3n1kindra]

this help me a lot, thanks

[@Dinookys]

🎉 save the day, thanks a lot

[@aryarizkysandi8351]

thank you very much for tutorial sir!!

[@cethartest469]

awesome, thanks you, please more and more advanced eloquent

[@LaravelDaily]

I have a full course about advanced eloquent: laraveldaily.teachable.com/p/laravel-eloquent-expert-level

[@amrqawasmeh]

Thx for the great content

[@rdvr]

Brilliant!

[@bmtamim7818]

You are awesome 😍

[@ahmedsyam]

Good job!

[@rishabhandari2501]

Helpful 🙌🖤

[@nbqenglishvietsubstyle117]

You are a god to me, thank you so so much

[@Raftor74]

Awesome!

[@my_religion]

Pretty helpful!

[@josuebarros5727]

This is cool!!!

[@programadorweb8403]

good work!!!

[@AlexTheGreatish]

This is great thank you.. Could you do a video explaining the different type of relationships and how the database structures should be set up in terms of where foreign keys are, etc?

[@LaravelDaily]

I have an article: blog.quickadminpanel.com/eloquent-relationships-the-ultimate-guide/
Also, it's best to read the docs: laravel.com/docs/8.x/eloquent-relationships

[@chibuikeumezinwa7827]

Lovely!

[@erh4rdt]

great, thank you!

[@muditgulgulia5350]

Best video. 👌

[@YT-Gmailer]

Thank you!

[@QianZhiwei]

very well. thank you.

[@claudiomenares4172]

Muchas gracias 🤯

[@berthojoris]

The best....Thanks

[@RANJEETKUMAR-wz4dg]

amazing thanks

[@fuhfaysal]

awesome!!

[@amgadalwattar2863]

very helpfull
thanks

[@aineelzihnee9634]

First time seeing video on youtube without dislike button being tick.

[@developer_sagor]

thank you very much

[@newtonsefa5721]

Thank you

[@ekselyum34]

Thanks 👏

[@devsun9063]

Thanks 🙏

[@surflaweb]

Amazing

[@ChangeYourLifeForever]

by this video you can understand the principle of has_many and belongs_to in other languages and frameworks also

[@achmadimanfirmansyah663]

thank you

[@mostafamahfouz1139]

thanks a lot

[@jimishukurow2286]

royal like from me!

[@GergelyCsermely]

Thanks

[@arashpirhadi1326]

great video thanks. :)
but i think in some situation like this performance will drop after 2 joins and more.
I mostly using DB facade for retrieving data from database.

[@LaravelDaily]

Yes, for complex queries raw queries are still the best.

[@GabrielMoura32]

thanks

[@afestacincome2224]

Can you please do a Short video on how to create nested comment and also a Short video on how to retweet a post ( Just like Twitter)

[@ikarahubs965]

Retweet feature will be nice

[@niffeydovie4906]

@@ikarahubs965 nested comment please

[@AbdulMajeedShehzad]

Thank you for the great video, I've a question for this scenario. is it a good practice to use keys in deep relations ? for example in employees table we add country_id to avoid complex queries when working on reporting. I've been looking for this answer for quite a long time

[@kauandouglas]

Up

[@javieru5871]

Feel you bro, done the same: usign foreign keys to those deep deep relationships

[@shofada]

Thanks or putting this together. If you had a page that needs to display say for every employee, the country, city and shop, what might the query look like?

[@ugayashan8659]

Great content, can you make a video on user referral system using laravel Eloquent

[@TechITWorld]

Could you make one video of belongstomany with three level deep query with where condition (with the last one)?

[@martinh4982]

Hi Povilas,
In Eloquent is it possible to join to an arbitrary sql statement? For example, say I have a User model and I want to create a UserStats relationship. However UserStats is not a table, but a sql statement that computes stuff like last_login, number_of_posts, up_votes etc. The only way I've found to do this so far is with a database view that I manage with migrations, but was wondering if this could be done purely in Laravel.

[@anisurrahman6634]

❤

[@fylzero]

The BelongsToThrough query actually became less efficient, no? It reduced the queries and models used but memory and time to execute increased.

[@gethermedel3620]

exactly, it slowed it down but it did simplify the work, so if you're application doesn't require or need the small performance difference, it's a good choice though.

[@Ayvengo21]

All the time i see that orm magic like this I'm asking myself does it worth it or maybe some escaped sql would be way easier to read and write. Because sql knowledge could be transferred between projects while knowledge of specific orm might be problematic.

[@akintandavid2500]

Thanks for this how can i learn more about eager loading

[@dApoTB]

Thanks for your videos! Could you please do one about constructing relationships between tables that are in different databases and connection names to those tables cannot be hard coded. E.g.: User table is in DB1, Post table is in DB2 and Comment table is in DB3. Can we construct a relationship here? Thanks!

[@SonsParaRelaxar]

It will work the same, the only thing you will have to do is overwrite the connection variable inside of the model.

[@insider-analyst]

composer require staudenmeir/belongs-to-through:"^2.5"
not installing on laravel 8

[@ilyasabdut]

what package did you used to showing relation and through text in the model?

[@taghreedomer6208]

really helped me with retrieving data, but what about insert data? is it possible to do so?

[@martinjones8231]

I follow all of your video u are great because the laravel path am on is just what u can teach so I need ur personal contact.

[@Formula7Driver]

What if we want to update data? I have a Sales Order, with Items, and each item has a list of Operation IDs to produce the item

[@yogeshwarbarai9686]

what ide setup you use ? It looks so good and to the point

[@LaravelDaily]

Phpstorm default

[@sir_brian_d]

6:03 the query count went down but the time & memory usage went up, less performant 🤔maybe it is not using an index

[@patihuuu6288]

What about A -> many to many -> B belongs to -> X, is possible using this package to access X from model A ?

[@erikgratz5539]

@ 8:00 you are showing off the functionality of `hasManyDeep` to associate employees with their countries. Could this also be achieved with an additional `hasManyThrough` definition? Where it is defined as `hasManyThrough(Employee::class, Shop::class)` ? Or do those methods not chain well / is this strictly better for performance?

[@renwar]

Very helpful video.
Why laravel framework does not have these kind of relationships yet?

[@LaravelDaily]

You're free to submit pull requests to the framework and add it.

[@razin223]

You do not show how to set search filter with "with" relation and its deep level with multiple column. Can you do that?