fssy/application/api/controller/Qc.php

<?php

namespace app\api\controller;
use app\api\controller\WeChart;
use think\Db;
class Qc{
    function index()
    {
        $sql = "SELECT uid , count(id) as num FROM `user_sign` where `month` = 11  GROUP BY uid  HAVING num > 6 ORDER BY num desc";
        $list = Db::query($sql);
        foreach ($list as $lv)
        {
            $sign_data = Db::table('user_sign')
                ->where('uid',$lv['uid'])
                ->where('month','11')
                ->order('id asc')
                ->limit(7)
                ->select();
            $sign_data=[
                'uid' =>$lv['uid'],
                'year' =>$sign_data[6]['year'],
                'month' =>$sign_data[6]['month'],
                'day' =>$sign_data[6]['day'],
                'type' =>'2',
                'create_at' =>$sign_data[6]['create_at'],
                'desc' => '恭喜亲通过累积签到7天获得10积分',
                'integral' => 10,
                'growth' => 10,
                'set_id' => 2,
            ];
            var_dump($sign_data);

        }
        var_dump($list);
    }






}