orderBy about laravel-translatable HOT 9 CLOSED

public function scopeTranslated($query)
{
    $translationTable = str_plural(snake_case(class_basename($this->getTranslationModelName())));
    $query->select()
        ->addSelect($this->getTable() . '.id as id')
        ->where('locale', App::getLocale())
        ->join(
            $translationTable,
            $this->getTable() . '.id',
            '=',
            $translationTable . '.' . $this->getRelationKey()
        );
    return $query;
}

Category::translated('Category')->orderBy('name')->get();

public function scopeTranslated($query, $model) {
        $model = preg_replace('/([A-Z])/', '_$1', $model);
        $model = strtolower($model);
        if (substr($model, 0, 1) == '_')
            $model = substr($model, 1);
        $pos = strrpos($model, 'y');
        if ($pos == strlen($model) - 1)
            $model_plural = substr_replace($model, 'ie', $pos, strlen($model));
        else
            $model_plural = $model;
        return $query->join($model.'_translations', $model_plural.'s.id', '=', $model.'_translations.'.$model.'_id')->where($model.'_translations.locale', '=', App::getLocale());
    }

$countries = Country::has('translations')->get();

$locale = 'en';
$countries = Country::whereHas('translations', function($q) use ($locale)
{
    $q->where('locale', '=', $locale);

})->get();