CODE EXAMPLE FOR PHP

laravel hasMany with join

public function earmarks() {
   return $this->hasMany('AppEarmark', 'labtop_id', 'id')
        ->join('locations', 'locations.id', '=', 'earmarks.location')
        ->select('earmarks.*', 'locations.location AS em_location')
        ->orderBy('date', 'asc')->get();
}