Eloquent manyThroughMany()

eloquent_manythroughmany.php

<?php

/*
 * manyTroughMany()
 *
 * Enables access to distant relations 
 * using many-to-many pivot tables.
 * 
 * Proposed by @terion-name at Laravel.io Forums
 * http://laravel.io/forum/03-04-2014-hasmanythrough-with-many-to-many
 *
 */

public function manyThroughMany($related, $through, $firstKey, $secondKey, $pivotKey) {

  $model = new $related;
  $table = $model->getTable();
  $throughModel = new $through;
  $pivot = $throughModel->getTable();

  return $model
    ->join($pivot, $pivot . '.' . $pivotKey, '=', $table . '.' . $secondKey)
    ->select($table . '.*')
    ->where($pivot . '.' . $firstKey, '=', $this->id);
}

?>