tp5.1带有搜索条件的查询

 $list = Db::name('member')
            ->alias('m')
            ->join('order o','m.id=o.uid')
            ->where(function($query)use($data){
                $search = isset($data['status'])?trim($data['status']):'';
                if($search !== ''){
                    $query->where('status',$search);
                }
            })
            ->where(function($query)use($data){
                $search = isset($data['uname'])?trim($data['uname']):'';
                if($search){
                    $query->where('nickname','like','%'.$search.'%');
                }
            })
            ->where(function($query)use($data){
                $search = isset($data['oid'])?trim($data['oid']):'';
                if($search){
                    $query->where('oid','like','%'.$search.'%');
                }
            })
            ->where(function($query)use($data){
                $search = isset($data['payway'])?trim($data['payway']):'';
                if($search){
                    $query->where('payway','like','%'.$search.'%');
                }
            })
            ->where(function($query)use($data){
                $search = isset($data['payway'])?trim($data['payway']):'';
                if($search){
                    $query->where('payway','like','%'.$search.'%');
                }
            })
            ->where(function($query)use($data){
                $search = isset($data['style'])?trim($data['style']):'';
                if($search){
                    $query->where('style',$search);
                }
            })
            ->order('o.create_time desc')->select();
            ```