Visual aid

HasManyThrough.php

// https://www.laravelhasmanythrough.com/

public function offices()
{
	/*
	 * SQL Query
	 *
	 SELECT
		`offices`.*,
		`office_user`.`user_id` ($1)
	FROM
		`offices`
		INNER JOIN `office_user` ON `office_user`.`office_id` ($4) = `offices`.`id` ($2)
	WHERE
		`office_user`.`user_id` = 1001119 ($3)
		ORDER BY offices.`code`
	 * */
	return $this->hasManyThrough(Office::class, OfficeUser::class,
		'user_id',  // $1 - SELECT ... `office_user`.`user_id`
		'id',       // $2 - ON ...  `offices`.`id`
		'user_id',  // $3 - WHERE `office_user`.`office_id` = 1001119
		'office_id' // $4 - ON `office_user`.`office_id` ...
	)->selectRaw('offices.*, CONCAT("#", code, " - ", name) as name')
		->orderBy('offices.code');
}