tp3.2中三表联查(join和 left join)

一;join:

            $orders = M('orders');
            $field = 'o.id, o.money, o.pay_type, o.status, o.score_before, o.score_after, o.ctime, u.realname AS username, s.platform AS sellername, c.realname AS companyname';


            


            //$totalRows = $orders->alias('o')->where('o.status > 0 ' . $where)->count('o.id');
            $totalRows = $orders->alias('o')->where($where)->count('o.id');
            


            $page = new \Think\Page($totalRows, $this->limit);


            $maxPages = ceil($totalRows/$this->limit);


            $curr = ($curr > $maxPages) ? $maxPages : $curr;


            $ordersList = $orders
                        ->alias('o')
                        ->field($field)