<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Spatie\Permission\Traits\HasRoles;
/**
* Class PaymentMethod
*/
class PaymentMethod extends Model
{
	use HasRoles;
	protected $table = 'ms_payment_method';
	protected $guarded = ['id'];
	public $timestamps = false; 
}

+----+-----------------+-----------------------+--------+---------------------+
| id | name            | note                  | status | created_at          |
+----+-----------------+-----------------------+--------+---------------------+
| 1  | COD             | Cash on Deliver       | 1      | 2020-11-20 10:30:07 |
+----+-----------------+-----------------------+--------+---------------------+
| 2  | Transfer Manual | Transfer ke rekeneing | 1      | 2020-11-20 10:31:08 |
+----+-----------------+-----------------------+--------+---------------------+
| 3  | Debit           | Kartu Debit           | 0      | 2020-11-20 10:32:09 |
+----+-----------------+-----------------------+--------+---------------------+

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Spatie\Permission\Traits\HasRoles;
/**
* Class Order
*/
class Order extends Model
{
	use HasRoles;
	protected $table = 'tr_orders';
	protected $guarded = ['id'];
	public $timestamps = false; 
	

	public function metodebayar(){
		return $this->belongsTo('App\Models\PaymentMethod', 'id_method','id');
	}
	 
}

<?php

namespace App\Http\Controllers\;

use App\Models\Order;
use Exception;
use Illuminate\Support\Facades\Session;

class OrderController extends Controller
{

	public function getOrderTransfer()
	{
		$data = Order::
		Orderby('id','desc')
			->whereHas('metodebayar', function($q) {
				$q->where('id', '2');
			})->get();
		return response($data, 500);
	}
		
}

Route::get('getordertr', 'App\Http\Controllers\OrderController@getOrderTransfer')->name('getordertr');