laravel orm query: get authors with one general film (films belongsTo authors)

laravel-authors-with-general-film.php

<php
// table authors: id, name
// table films: id, name, general(boolean), author_id

Authors::leftJoin('films as general_film', function ($q) {
    $q->on('authors.id', '=', 'general_film.author_id')
        ->on('general_film.id', '=',
            DB::raw('(select id from films WHERE author_id = authors.id ORDER BY general DESC LIMIT 1)'));
});