Tp5 syntax group by is used with count (*)

like Table
Fields
id
typeid article id
userid user id
status like status 1: liked 0: not liked

I want to know that the id of an article is the total number of likes of 1br 2 code 3 group by typeid 4. I don"t know how to use tp5 to write
Native sql= "select typeid,count (*) from like where typeid in (1 Magazine 3 Magazine 4) and user_id = 14 and status = 1 group by typeid";

tp5 only knows how to write
$ids="1
LikeModel::where ("typeid","in",$ids)-> where ([" user_id"= > 14 minute statuses = > 1)-> group ("typeid")-> select ();

count (*) is not used

I want to implement
typeid count (*)
1
22
3 2
4 1

Mar.03,2021

in fact, the filed method is used in this one. For example,

LikeModel::where('typedid','in',$ids)
    ->where(['user_id'=>14,'status'=>1])
    ->filed('typeid,COUNT(*) as total')
    ->group('typeid')
    ->select();

not too much to check, that's about what it means

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-1b314dd-2bd98.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-1b314dd-2bd98.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?