显示效果



解决办法：

$db_com=Db::name("member")

        ->alias('a')

        ->join('lj_collect_stow s','a.id=s.member_id')

        ->field('a.id as mid,a.nickname,s.*,count(s.id) as tot,sum(s.stowtypeid=3 and s.add_time > '.$start_time.' and s.add_time <= '.$end_time.') as b2,sum(s.stowtypeid=6 and s.add_time > '.$start_time.' and s.add_time <= '.$end_time.') as p1')

        ->group('s.member_id')

        ->paginate($pages,false,['query'=>request()->param()]);