$posts = Post::with(['author', 'comments.user'])->get();
foreach ($posts as $post) {
echo $post->author->name;
foreach ($post->comments as $comment) {
echo $comment->user->name;
}
}
- Query 1:
SELECT * FROM posts - Query 2:
SELECT * FROM users WHERE id IN (?, ?, ?) (authors) - Query 3:
SELECT * FROM comments WHERE post_id IN (?, ?, ?) (comments) - Query 4:
SELECT * FROM users WHERE id IN (?, ?, ?) (comment users)