$data = Db::name(‘third’)->alias(‘t’)
    ->join(‘admin a’,’t.create_id = a.id’,’LEFT’)
    ->join(‘admin a2’,’t.update_id = a2.id’,’LEFT’)
    ->join(‘third_images ti’,’ti.third_id = t.id’,’LEFT’)
    ->join(‘supplier s’,’s.id = t.supplier_id’,’LEFT’)
    ->join(‘organization o’,’o.id = s.organization_id’,’LEFT’)
    ->join(‘third_type tt’,’tt.id = t.type_id’,’LEFT’)
    ->join(‘contract c’,’c.id = t.contract_id’,’LEFT’)
    ->field(‘t.*, a.nickname as create_name, a2.nickname as update_name, o.name as supplier_name, tt.type_name, (select img from tourism_third_images tti where tti.third_id = t.id group by tti.third_id) as img, c.contract_num’)
    ->where(‘t.status > 0’)
    ->group(‘t.id’)
    ->order(‘t.id desc’)
    ->paginate(10);