The problem of repeating the sports date?

:
public function getMemberPhysicalTestDate()
{
    $arr = MemberPhysicalTest::find()
        ->alias("mpt")
        ->joinWith(["member m"],FALSE)
        ->where([
            "m.member_account_id" => $this->accountId,
            "mpt.type" => $this->type,
            "mpt.is_delete" => 0
        ])
        ->select("mpt.create_at")
        ->groupBy(["DATE_FORMAT(from_unixtime(mpt.create_at),"%Y-%m-%d")"])
        ->orderBy("mpt.create_at desc")
        ->asArray()
        ->all();
    return $arr;
}

clipboard.png

clipboard.png
this method doesn"t work very well: only the first item is found, and the second one is not found on June 26th.

Php yii
Mar.22,2021 
public function getMemberPhysicalTestDate()
{
    $arr = MemberPhysicalTest::find()
        ->alias('mpt')
        ->joinWith(['member m'],FALSE)
        ->where([
            'm.member_account_id' => $this->accountId,
            'mpt.type' => $this->type,
            'mpt.is_delete' => 0
        ])
        ->select(["DATE_FORMAT(mpt.create_at,'%Y-%m-%d') as testDate"])
        ->groupBy(["DATE_FORMAT(mpt.create_at,'%Y-%m-%d')"])
        ->orderBy('mpt.create_at desc')
        ->asArray()
        ->all();
    return $arr;
}
groupByfrom_unixtimeok

Previous: Mini Program reported an error when introducing Mini Program's plug-in into the wepy framework.

Next: What's the difference between the way js creates classes function and class?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e54c33-44a66.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e54c33-44a66.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?