Joining the table for different relationships

[younus93]

Hi,

I have a Task model with the columns created_by, assigned_to. These columns are mapped to the users table via the hasOne relationship.
(ie)

public function assignedTo()
{
    return $this->belongsTo(User::class, 'assigned_to');
}

public function createdBy()
{
    return $this->belongsTo(User::class, 'created_by');
}

I want to display these in columns and search by the name column on the users table.

How do i go about doing this?