Rekursif

function getDealer($keyword,$bulan,$tahun){
        $query = $this->db->query("SELECT intid_dealer,strnama_dealer, strkode_dealer,intid_unit, intlevel_dealer, strnama_upline, strkode_upline
        FROM member a WHERE a.strkode_upline = '".$keyword."'");
        $j=0;
        $data=array();
        $data2=array();
        $data1=array();
        $i=0;
        foreach ($query->result() as $row) {
            /*looping pencarian anak */
            $data[$j]['upline'] = $row->strkode_upline;
            $data[$j]['dealer'] = $row->strkode_dealer;
            $data[$j]['lvl']  =  $row->intlevel_dealer;
            $data[$j]['unit'] = $row->intid_unit;
            $data[$j]['iddealer'] = $row->intid_dealer;

            $query1 = $this->db->query("SELECT intid_dealer,strnama_dealer, strkode_dealer,intid_unit, intlevel_dealer, strnama_upline, strkode_upline FROM member a WHERE a.strkode_upline = '".$row->strkode_dealer."'");

            foreach ($query1->result() as $row1) :
            $data2[$j]['upline'] = $row1->strkode_upline;
            $data2[$j]['dealer'] = $row1->strkode_dealer;
            $data2[$j]['lvl']  =  $row1->intlevel_dealer;
            $data2[$j]['unit'] = $row1->intid_unit;
            $data2[$j]['iddealer'] = $row1->intid_dealer;


                echo "Upline : ".$data2[$j]['upline']."<br>";
                echo "Dealer : ".$data2[$j]['dealer']."<br>";
                echo "Level Dealer : ".$data2[$j]['lvl'] ."<br>";
                echo "Unit : ".$data2[$j]['unit'] ."<br>";
                echo "ID Dealer : ".$data2[$j]['iddealer'] ."<br>";
                echo "<br>";

            /*cari berdasarkan child*/
                    $penjualan = $this->db->query("
                            SELECT
                                intid_dealer,
                                intid_unit,
                                intid_jpenjualan,
                                intid_cabang,
                                intid_week,
                                SUM(intomset10) AS total_omset10,
                                SUM(intomset20) AS total_omset20,
                                SUM(inttotal_omset) AS total_omset
                            FROM
                                nota
                            WHERE
                                (
                                    intid_jpenjualan = 1
                                    OR intid_jpenjualan = 9
                                )
                            AND intid_unit = ".$data2[$j]['unit']."
                            AND intid_week IN (
                                SELECT
                                    intid_week
                                FROM
                                    WEEK
                                WHERE
                                    intbulan = '".$bulan."'
                                AND inttahun = '2014'
                            )
                            AND intid_dealer = ".$data2[$j]['iddealer']."
                            AND YEAR (datetgl) = '".$tahun."'
                            GROUP BY
                                intid_dealer,
                                intid_nota
                        ");
                        foreach ($penjualan->result() as $pen) :

                            if(!empty($pen)):
                            $data1[$i]['dealer'] = $pen->intid_dealer;
                            $data1[$i]['unit'] = $pen->intid_unit;
                            $data1[$i]['jenispenjualan'] = $pen->intid_jpenjualan;
                            $data1[$i]['cabang'] = $pen->intid_cabang;
                            $data1[$i]['week'] = $pen->intid_week;
                            $data1[$i]['totomset10'] = $pen->total_omset10;
                            $data1[$i]['totomset20'] = $pen->total_omset20;
                            $data1[$i]['totomset'] = $pen->total_omset;

                            echo "ID Dealer : ".$data1[$i]['dealer']."<br>";
                            echo "Unit : ".$data1[$i]['unit']."<br>";
                            echo "Jenis penjualan:".$data1[$i]['jenispenjualan']."<br>";
                            echo "Cabang : ".$data1[$i]['cabang']."<br>";
                            echo "Week : ".$data1[$i]['week']."<br>";
                            echo "TotOmset10 : ".$data1[$i]['totomset10']."<br>";
                            echo "TotOmset20 : ".$data1[$i]['totomset20']."<br>";
                            echo "TotOmset".$data1[$i]['totomset']."<br>";
                            endif;
                            $i++;
                        endforeach;
                    endforeach;
                    $this->getDealer($data[$j]['dealer'],$bulan,$tahun);
            $j++;
        }
        return $data1;
    }