get column in relation tables

[aivisionbot]

i use this query in builder() :

public function builder(): Builder
{
$query = Wallet::query()
->leftJoin('users', 'users.id', '=', 'wallets.holder_id')
->select('wallets.*', 'users.username as username');

    return $query;
}

I want to create a username column in my table:

Column::make("Username", "username")
->searchable(),

But I encounter this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wallets.username' in 'field list'

And when I use this code:
Column::make("Username", "users.username")
->searchable(),

I get this error:
Call to undefined relationship [users] on model [Bavix\Wallet\Models\Wallet].

I do not want to use the relationship inside the model; I want to use join in the builder. Please guide me, thank you.

[lrljoe]

Why do you not want to establish a relation within your Wallet model to User model?

If you establish/define joins, then you can of course use a label() method on the column, which will prevent it from trying to be part of the query

However I'd still likely to understand the use case behind why you want to abandon Eloquent relations

[aivisionbot]

Thank you for your answer. The relationship between user and wallet model is hasMany() and I could not display this relationship in the table.

[lrljoe]

I'm very confused by this answer to be honest.

You're using a join, that shows that a wallet "belongsTo" a user (i.e. it has one user associated with it via the 'holder_id' field), but you're then saying it hasMany users?

I'm assuming
User -> (hasMany) -> Wallet
Wallet -> (belongsTo) -> User

i.e.
"users.id" maps to "wallets.holder_id"
A single "users.id" may exist in multiple "wallet" records with the primary key being in the "holder_id" of "wallets", but a "wallet" record can only have a single "holder_id"

Why does Wallet not have a User relationship against it, or have you named the relation "Holder" or similar?

You should be avoiding using joins throughout your Laravel project, and using the relationship methods instead unless there's a really specific/niche/edge case (which is clearly not present here).