The whereHas method doesn't work for self relations

[wgcontrol]

I have a relation in my User model:

public function referrer(): BelongsTo
{
    return $this->belongsTo(
        User::class , 
        ['referrer_id', 'bot_id'], 
        ['id', 'bot_id']
    );
}

And when i call the whereHas method:

User::whereHas('referrer', fn ($query) => $query->whereKey(121));

I give this error:

[2024-11-26 12:49:33] local.ERROR: Array to string conversion {"exception":"[object] (ErrorException(code: 0): Array to string conversion at /www/wwwroot/matrix/vendor/awobaz/compoships/src/Database/Eloquent/Relations/BelongsTo.php:288)
[stacktrace]
#0 /www/wwwroot/matrix/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(254): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /www/wwwroot/matrix/vendor/awobaz/compoships/src/Database/Eloquent/Relations/BelongsTo.php(288): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /www/wwwroot/matrix/vendor/awobaz/compoships/src/Database/Eloquent/Relations/BelongsTo.php(197): Awobaz\\Compoships\\Database\\Eloquent\\Relations\\BelongsTo->getRelationExistenceQueryForSelfRelation()
#3 /www/wwwroot/matrix/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/QueriesRelationships.php(54): Awobaz\\Compoships\\Database\\Eloquent\\Relations\\BelongsTo->getRelationExistenceQuery()

[wgcontrol]

I fix this error by chaging the BelongsTo class and overriding the getRelationExistenceQueryForSelfRelation method.

public function getRelationExistenceQueryForSelfRelation(Builder $query, Builder $parentQuery, $columns = ['*'])
{
    $query->select($columns)->from(
        $query->getModel()->getTable().' as '.$hash = $this->getRelationCountHash()
    );

    $query->getModel()->setTable($hash);

    $ownerKeys = (array) $this->ownerKey;
    $qualifiedForeignKeyNames = (array) $this->getQualifiedForeignKeyName();
    
    foreach ($ownerKeys as $index => $ownerKey) {
        return $query->whereColumn(
            $hash.'.'.$ownerKey, '=', $qualifiedForeignKeyNames[$index]
        );
    }

    return $query;
}