如何在laravel控制器中从3个(多个)表中检索数据？

class User extends Model
{
    public function posts()
    {
        return $this->hasMany(Post::class);
    }
}

class Post extends Model
{
    public function comments()
    {
        return $this->hasMany(Comment::class);
    }
}

use App\Models\User;

class UserController extends Controller
{
    public function index()
    {
        $user = User::with('posts.comments')->find(1);

        // 获取用户的所有文章
        $posts = $user->posts;

        foreach ($posts as $post) {
            // 获取每篇文章的评论
            $comments = $post->comments;

            // 处理评论数据
            // ...
        }

        // 返回数据或视图
        // ...
    }
}