Not working with join()

[n-o-o-b-z]

It is not working using laravel join()

[Onkar-php-digi]

Same have you find any solution ?

[n-o-o-b-z]

not yet, I'm still waiting, how about you?

[Onkar-php-digi]

I have sorted it with Laravel relations, and it works fine for me.

$data_message = []; $results = Message::with(['fromUser' => function ($query) { $query->select('id', 'name', 'email', 'image'); }]) ->where('to_user_id', $user_id) ->where('is_read',0) // ->groupBy('from_user_id') ->orderBy('id','DESC') ->get(); $results = $results->unique('from_user_id');