select a.* , b.*, c.*, d.* ,(select count(*) from simdik_nilai_akhir_siswa where jadwal_id = a.id_jadwal) as peserta
from simdik_jadwal a join simdik_kelas b on a.kelas_id = b.id join simdik_pegawai c on a.pengajar_id = c.no_induk join simdik_matapelajaran d on a.pelajaran_id= d.id

question is :
what can I do? if I want change this query to query in codeigniter.

attentions :
thanks and God Bless You for all PHP developer

I am Newbie but smart