JOIN CI4

JOIN IN CI4  :

 $TeachersClassModels = new TeachersClassModels();

            $data['TeachersClassModels'] =$TeachersClassModels->table('teachers_classes')

                ->select('teachers_classes.*,classes.id as idfc,classes.name as nfc')

                ->join('classes', 'classes.id = teachers_classes.class_id')

                ->where('teachers_classes.institute_id', $_SESSION['institutes'])

                ->where('teachers_classes.teacher_id', $_SESSION['id'])

                ->findAll();