<?php
$language = 104;
$words = \DB::table('words')
->leftJoin(
'word_translations',
'word_translations.word_id', '=', 'words.id')
->where('word_translations.language_id', '=', $language)
->select('words.code_name', 'word_translations.name')
->get();
$translations = [];
foreach($words as $word){
$translations[$word->code_name] = $word->name;
}
return $translations;