Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column

i have this error in laravel eloquent query :

"Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column"

    $data = DB::table('passages')
        ->select('passages.*','users.name','users.family','valid_users.user_id','valid_users.valid_card_id','valid_users.valid_card_decimal','valid_users.valid_card_hex')
        ->join('valid_users','valid_users.id','=','passages.valid_user_id')
        ->join('users','valid_users.user_id','=','users.id')
        ->join('accounts','accounts.user_id','=','users.id')
        ->whereIn('accounts.role_id',$roles)
        ->groupBy('valid_user_id')
        ->get();

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2Ot9gio
via IFTTT