【Laravel】リレーション先のカラムや合計値を対象にソートする

<?php

namespace App\Models;

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

class Post extends Model
{
    use HasFactory;

    /**
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */
    public function category(): BelongsTo
    {
        return $this->belongsTo(Category::class);
    }
}

Post::with(['category' => function ($query){
  $query->orderBy('sort');
}])->get();

User::with(['post.category' => function ($query){
  $query->orderBy('sort');
}])->get();

User::withCount([
        'posts AS total_view_count' => function ($query) {
          $query->select(DB::raw("SUM(view_count) as view_count_sum"));
         }
      ])->orderBy('total_view_count', 'desc')
      ->get();