我有3路关系第一我有这样的代码在一个控制器

Trial::with('subjects')->where('source_id', $sourceId)->get()->toArray()

现在我想按subject.reactions.accounts.nb_followers列的降序对subject. reactions进行排序。我尝试在关系上使用orderby，但它不起作用，因为它按reactions对帐户indsted进行排序。我想根据帐户表中“nb_followes”列的值对reactions进行排序。
试验模型

class Trial extends Model
{
    use HasFactory;
    public $table = 'trials';

    public function subjects()
    {
        return $this->hasMany(Subject::class, 'trial_id')->with(['reactions', 'news'])->withCount('reactions');
    }
  }

主题模型

class Subject extends Model
{
    use HasFactory;
    public $table = 'subjects';

    public function reactions()
    {
        return $this->hasMany(Reaction::class, 'subject_id', 'id')->with(['accounts' => function ($q) {$q->orderBy('nb_followers', 'DESC');}])->where('twitter_error', 0)->where('active', 1)->orderby('key_reaction', 'DESC');
    }

    public function news()
    {
        return $this->hasone(News::class, 'id', 'news_item_id');
    }

React模型

class Reaction extends Model
{
    use HasFactory;

    public $table = 'reactions';

    public function accounts()
    {
        return $this->belongsTo(Account::class, 'account_id', 'id')->where('name', '!=', '');
    }

提前感谢您。

I want to sort reactions based on account table's column yes i cant use simple eloquent query because it will not create a structure that i want so that's why i created these relationships.