Eloquentで自分の投稿とフォローしてる人の投稿を投稿日時の降順に取得する方法が分からない

Question

前提・実現したいこと

自分の投稿一覧の取得はできたのですが、それにフォローしてる人の投稿を含めたものの取得方法がわかりません。
MySQLで言うと下記のようなことをEloquentで行いたいです。

select * from comments join followings on comments.user_id = followings.following_user_id where followings.user_id = 任意のid order by comments.created_at desc;

該当のソースコード

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Following extends Model
{
    use HasFactory;

    protected $fillable = [
        'user_id',
        'following_user_id',
    ];

    public function user()
    {
        return $this->belongsTo(User::class, 'user_id', 'id');
    }

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

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use App\Models\Article;
use App\Models\User;

class Comment extends Model
{
    use HasFactory;

    protected $fillable = [
        'body',
        'user_id',
        'article_id',
    ];

    public function article()
    {
        return $this->belongsTo(Article::class);
    }

    public function user()
    {
        return $this->belongsTo(User::class);
    }
}

namespace App\Models;

use App\Models\Comment;

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

    // フォローしてる人全て取得
    // $follows = auth()->user()->follows()->get();
    public function follows()
    {
        return $this->belongsToMany(User::class, 'followings', 'user_id', 'following_user_id')->withTimestamps();
    }
}

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\User;
use App\Models\Comment;
use Auth;

class UserController extends Controller
{
    public function index()
    {
        $user = Auth::user();
        $comments = $user->follows->comments->whereId($user->id)->get();
        dd($comments);
        exit;
        // $comments = $user->comments()->latest()->get();

        return view('index', [
            'user' => $user,
            'comments' => $comments,
        ]);
    }

+------------+-----------------+------+-----+---------+----------------+
| Field      | Type            | Null | Key | Default | Extra          |
+------------+-----------------+------+-----+---------+----------------+
| id         | bigint unsigned | NO   | PRI | NULL    | auto_increment |
| user_id    | bigint unsigned | NO   | MUL | NULL    |                |
| article_id | bigint unsigned | NO   | MUL | NULL    |                |
| body       | text            | YES  |     | NULL    |                |
| created_at | timestamp       | YES  |     | NULL    |                |
| updated_at | timestamp       | YES  |     | NULL    |                |
+------------+-----------------+------+-----+---------+----------------+

+-------------------+-----------------+------+-----+---------+----------------+
| Field             | Type            | Null | Key | Default | Extra          |
+-------------------+-----------------+------+-----+---------+----------------+
| id                | bigint unsigned | NO   | PRI | NULL    | auto_increment |
| user_id           | bigint unsigned | NO   | MUL | NULL    |                |
| following_user_id | bigint unsigned | NO   | MUL | NULL    |                |
| created_at        | timestamp       | YES  |     | NULL    |                |
| updated_at        | timestamp       | YES  |     | NULL    |                |
+-------------------+-----------------+------+-----+---------+----------------+

```usersテーブル
+-------------------+-----------------+------+-----+---------+----------------+
| id                | bigint unsigned | NO   | PRI | NULL    | auto_increment |
| name              | varchar(255)    | NO   |     | NULL    |                |
| email             | varchar(255)    | NO   | UNI | NULL    |                |
| email_verified_at | timestamp       | YES  |     | NULL    |                |
| password          | varchar(255)    | NO   |     | NULL    |                |
| remember_token    | varchar(100)    | YES  |     | NULL    |                |
| created_at        | timestamp       | YES  |     | NULL    |                |
| updated_at        | timestamp       | YES  |     | NULL    |                |
+-------------------+-----------------+------+-----+---------+----------------+

補足情報（FW/ツールのバージョンなど）

PHP 8.1.1
Laravel 8.79.0

Answer 1

リンクを参考にEloquentのleftjoinでテーブル二つを結合し自分とフォローユーザーの投稿が取得できました

$comments = Comment::leftjoin('followings', 'comments.user_id', '=', 'followings.following_user_id')->where('followings.user_id', $user->id)->orwhere('comments.user_id', $user->id)->select('comments.*')->latest('comments.created_at')->get();

Laravel 5.1 入門記 その10 (Eloquent SELECT 編)

LaravelでINNER JOIN / LEFT JOIN [クエリビルダ/Eloquent]