Untitled

$izin = $this->db->table('tbl_izin')
        ->select('id_karyawan, status_izin, COUNT(DISTINCT tgl_izin) AS durasi_hari')
        ->where('id_karyawan', $id_karyawan_login)
->where('status_izin', 'izin')
        ->groupBy('id_karyawan, status_izin')
        ->get()->getResultArray();

$sakit = $this->db->table('tbl_izin')
        ->select('id_karyawan, status_izin, COUNT(DISTINCT tgl_izin) AS durasi_hari')
        ->where('id_karyawan', $id_karyawan_login)
->where('status_izin', 'sakit')
        ->groupBy('id_karyawan, status_izin')
        ->get()->getResultArray();

    return [
        'izin' => $izin,
        'sakit' => $sakit,
    ];