$keyword=$request->input();
$list = DB::table("user as a")
->leftJoin('students as b', 'b.id', '=', 'a.sid')
->where(function($query) use($keyword) {
if(!empty($keyword["keyword"])){
$name=$keyword["keyword"];
$query->Where('user_name','like',"%$name%");
$query->orWhere('alias_name','like',"%$name%");
$query->orWhere('mobile','like',"%$name%");
}
})
->where(function($query) use($keyword) {
if(!empty($keyword["mid"])){
$query->where('mid',$keyword["mid"]);
}
})
->select(['b.*',,'b.id as b_id','a.*','a.id as a_id','a.name as a_name','b.name as b_name'])
->orderBy("a.id","desc")
->paginate(15);
