你必须使用连接。在获取多对多关系时，eloquent会创建两个查询。不幸的是，在这种情况下不能使用order by。
更新
查询生成器将是您的最佳选择，不幸的是，被接受的答案将是非常低效的，至少不能很好地扩展。在我脑子里，这个问题大概是这样的：

$orders = DB::table('orders')
    ->leftJoin('order_order_status', 'orders.id', '=', 'order_order_status.order_id')
    ->leftJoin('order_statuses', function ($join) use ($title) {
         $join->on(
             'order_order_status.order_status_id',
             '=',
             DB::raw('SELECT id FROM order_statuses WHERE title = ' . $title . ' AND order_order_status.order_status_id = order_statuses.id ORDER BY created_at DESC LIMIT 1')
         );
    })
    ->select('orders.*')
    ->groupBy('orders.id')
    ->get();

php工匠make:model user
在您的用户模型中：

protected $table='users';
   public $primaryKey='id';

 public function orders(){
    return $this->belongsToMany('App\Model\Orders','order_order_status','user_id','order_id')->orderby('created_at','desc');
 }

php工匠make:model order
在您的订单型号中：

protected $table='orders';
  public $primaryKey='id';

  public function user(){
    return $this->belongsTo('App\Model\User','user_id');
  }

 public function order_status()
  {
   return $this->belongsToMany('App\Model\OrderStatus','order_order_status','order_id','order_status_id')->withTimestamps();
  }

php工匠make:model orderstatus
在orderstatus模型中：

protected $table='order_statuses';
  public $primaryKey='id';

 public function orders()
    {
        return $this->belongsToMany('App\Model\Order','order_order_status')->with('user')->orderBy('created_at','desc');
    }

php工匠make:controller orderscontroller
现在您想通过orderstatus title='quote'获取订单
在orderscontroller中：

use Illuminate\Http\Request;

 public function get_order(Request $request,$title){
         // $title='Quote';
         $orders=OrderStatus::where('title',$title)->with('orders')->get();
         return response()->json($orders);
    }

您需要在每个模型中添加一些关系才能将它们连接起来

订单

namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class orders extends Model 
{
    protected $table = 't_orders';
    protected $primaryKey = 'id';

    // join t_orders with t_order_order_status but get only the latest matching row out of order_order_status
    public function status_log()
    {
        return $this->hasMany('App\Model\order_order_status', 'order_id','id')->orderBy('t_order_order_status.id', 'desc')->limit(1);
    }

}

订单\订单\状态

namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class order_order_status extends Model 
{
    protected $table = 't_order_order_status';
    protected $primaryKey = 'id';

    // join t_orders with t_order_order_status
    public function status_name()
    {
        return $this->hasOne('App\Model\order_statuses', 'id','order_status_id');
    }

}

订单状态

namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class order_statuses extends Model 
{
    protected $table = 't_order_statuses';
    protected $primaryKey = 'id';

}

然后你就会这样做

App\Model\orders::with('status_log.status_name')->get();

应该买这样的东西

[  
   {  
      "id":2,
      "user_id":73,
      "order_number":"37-5",
      "job_reference":"Janis Joplin",
      "accounting_reference":null,
      "created_at":"2018-06-25 02:27:21",
      "updated_at":"2018-06-25 02:27:21",
      "status_log":[{  
        "id":4,
        "order_id":2,
        "order_status_id":4,
        "user_id":753,
        "created_at":"2012-06-27 09:56:00",
        "updated_at":"2012-06-27 09:56:00",
        "status_name":{  
           "id":4,
           "title":"Confirmed",
           "tag":"confirmed",
           "created_at":"2018-06-25 02:25:28",
           "updated_at":"2018-06-25 02:25:28"
        }
      }]
   }
]

注意，我在表名前面加了 t_ 但是你可以把它们命名为和你的模型一样的名字。
更新
为此，您可以使用这样的方法传递一个clusre，该clusre将根据状态id进行过滤

$status = 3;

$result =  App\Model\orders::with(['status_log'=>function($query) use($status) {

    $query->where('t_order_order_status.order_status_id','=', $status);

    $query->with('status_name');

}])->get();

return $result;

将给予

[{  
      "id":2,
      "user_id":73,
      "order_number":"37-5",
      "job_reference":"Janis Joplin",
      "accounting_reference":null,
      "created_at":"2018-06-25 02:27:21",
      "updated_at":"2018-06-25 02:27:21",
      "status_log":[{                       // will be empty [] for order not in t_order_order_status
        "id":3,
        "order_id":2,
        "order_status_id":3,
        "user_id":753,
        "created_at":"2012-06-27 09:56:00",
        "updated_at":"2012-06-27 09:56:00",
        "status_name":{  
               "id":3,
               "title":"Order",
               "tag":"order",
               "created_at":"2018-06-25 02:25:28",
               "updated_at":"2018-06-25 02:25:28"
        }
     }]

   }]

它将返回所有订单，但您可以使用 status_log 弄清楚它在 t_order_order_status 表中，但如果您想删除“额外”并仅保留记录器表中存在的那些订单，则可以在 $result .

return $result->filter(function ($item) {
    return !empty($item->status_log && count($item->status_log));
});