根据用户ID为1的条件查询 status为 1 的有多少条,status为 2的有多少条,自己根据实际情况修改sql 语句
SELECT SUM(IF(status=1,1,0)) AS A,SUM(IF(status=2,1,0)) AS B
FROM t_students
WHERE userId = 1
SELECT SUM(IF(status=1,1,0)) AS A,SUM(IF(status=2,1,0)) AS B
FROM t_students
WHERE userId = 1