之前写了一个遇到了多表查询的问题，现在就来写一下：


$data = DB::table('stu_searches')         //将两张表拼接起来
      ->join('stu_msgs', function($join)
      {
          $join->on('stu_searches.stu_id', '=', 'stu_msgs.stu_id');
      })->select('stu_searches.id', 'stu_searches.stu_id','stu_searches.username','stu_searches.stu_name',
      'stu_searches.stu_sign','stu_searches.stu_sex','stu_searches.stu_age','stu_searches.stu_num',
      'stu_searches.stu_addr','stu_searches.stu_course','stu_searches.stu_grade','stu_searches.stu_intro',
      'stu_searches.stu_pic','stu_searches.stu_collect','stu_searches.stu_bcost','stu_searches.stu_lcost',
      'stu_searches.free_time','stu_searches.volTime','stu_searches.kind',
      'stu_searches.created_at','stu_msgs.num','stu_msgs.stu_star','stu_msgs.real_sign')
        ->skip($pageSize*($pageIndex))   //$pageIndex是页码  <span style="color:#ff0000;"><strong><u>即一次会跳过几个数据</u></strong></span>
        ->limit($pageSize)                 //$pageSize限制一次获取的数据条数
        ->orderBy('stu_searches.id', 'desc')
        ->get();


**其中要注意下需要挑选自己想要的数据，否则获取了两张表的字段，且同名字段会出现覆盖混乱