<?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;