Left join id is null when $incrementing = false

[paulm17]

Thanks for the library!

I have the following:

Tables:
CREATE TABLE font_awesome_categories (
    `id` binary(26) NOT NULL,
    `name` varchar(50) NOT NULL,
);

CREATE TABLE font_awesome_icons (
    `id` binary(26) NOT NULL,
    `type` varchar(10) NOT NULL,
    `prefix` varchar(3) NOT NULL,
    `icon` varchar(50) NOT NULL,
    `unicode` varchar(10) NOT NULL,
);

CREATE TABLE font_awesome_icon_categories (
    `id` binary(26) NOT NULL,
    `category_id` binary(26) NOT NULL,
    `icon_id` binary(26) NOT NULL,
);

SQL:
select fai.id, fac.category_id, type, prefix, icon, unicode 
from font_awesome_icons fai 
left join font_awesome_icon_categories fac on fac.icon_id = fai.id 
order by icon asc;

Model:
class FontAwesomeIcon extends Model
{
    public function categories()
    {
        return $this->hasManyThrough(            
            'App\Models\ContentEditor\FontAwesomeCategory', 
            'App\Models\ContentEditor\FontAwesomeIconCategory',
            'icon_id', // Foreign key on faIconCategory table...
            'id', // Foreign key on faCategory table...
            'id', // Local key on faIcon table...
            'category_id' // Local key on faIconCategory table...
        );
    }
}

Query:
$result = FontAwesomeIcon::leftJoin('font_awesome_icon_categories', 'font_awesome_icon_categories.icon_id', '=', 'font_awesome_icons.id')
    ->with('categories')
    ->orderBy('icon')
    ->get();

The id field is null:

attributes: array:11 [▼
    "id" => null
    "type" => "brands"
    "prefix" => "fab"
    "icon" => "500px"
    "unicode" => "f26e"
    "created_at" => null
    "updated_at" => null
    "deleted_at" => null
    "category_id" => null
]

Although I can resolve it for now, by adding a select to the query:

->select(
    'font_awesome_icons.id as id', 
    'font_awesome_icon_categories.category_id', 
    'font_awesome_icons.type',
    'font_awesome_icons.prefix',
    'font_awesome_icons.icon',
    'font_awesome_icons.unicode'
)