我在 Laravel 中定義了 3 個表，如下所示：Schema::create('locales', function (Blueprint $table) {    $table->string('id', 2);    $table->string('name', 5000);    $table->timestamps();    $table->primary('id');});Schema::create('i18n_keys', function (Blueprint $table) {    $table->string('id', 255);    $table->timestamps();    $table->primary('id');});Schema::create('i18ns', function (Blueprint $table) {    $table->bigIncrements('id');    $table->string('key', 255);    $table->string('locale', 2);    $table->string('translation', 5000)->nullable();    $table->timestamps();                $table->foreign('key')->references('id')->on('i18n_keys')->onDelete('cascade')->onUpdate('cascade');    $table->foreign('locale')->references('id')->on('locales')->onDelete('cascade')->onUpdate('cascade');    $table->unique(array('key', 'locale'));});現在的問題是如何SELECT以編程方式在 Laravel 中實現以下語句。我的意思是不直接運行 SQL 語句。SELECT `il`.`key`, `il`.`locale`, `in`.`translation` FROM (SELECT `ik`.`id` AS `key`, `lo`.`id` AS `locale` FROM `i18n_keys` as `ik` CROSS JOIN `locales` as `lo`) AS `il` left join `i18ns` as `in` ON `in`.`key` = `il`.`key` and `in`.`locale` = `il`.`locale`;目的是提取他們還沒有翻譯的鍵。但我喜歡使用查詢生成器或 eloquent 或類似的東西來執行此操作，而不是直接傳遞查詢。有什么辦法嗎？