之前写了一个遇到了多表查询的问题，现在就来写一下：
$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();$data = DB::t
