whereNotNull('channel_id') ->where('role', 'student') ->whereIn('status', ['joined', 'accepted', 'agreed']) ->select('channel_id') ->orderBy('created_at') ->get(); foreach ($studentsChannel as $key => $channel) { $channels[] = $channel->channel_id; } return $channels; } public static function role($courseId, $userUid) { $role = CourseMember::where('course_id', $courseId) ->where('user_id', $userUid) ->where('is_current', true) ->value('role'); return $role; } }