MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table yourtable (cab int, name varchar(3), value int);
insert into yourtable values
(1,'PHP',1),
(1,'PHP',2),
(1,'PHP',0),
(2,'LHL',0),
(3,'GHG',3),
(3,'GHG',2),
(4,'TXT',NULL);

Records: 7  Duplicates: 0  Warnings: 0


SELECT 
  cab,
  name,
  SUM(value = 0) AS "value=0",
  SUM(value > 0) AS "value>0"
FROM yourtable
GROUP BY 
  cab, name
ORDER BY 
  cab


cab
name
value=0
value>0


1
PHP
1
2

2
LHL
1
0

3
GHG
0
2

4
TXT
null
null


SELECT 
  cab,
  name,
  COALESCE(SUM(value = 0),0) AS "value=0",
  COALESCE(SUM(value > 0),0) AS "value>0"
FROM yourtable
GROUP BY 
  cab, name
ORDER BY 
  cab


cab
name
value=0
value>0


1
PHP
1
2

2
LHL
1
0

3
GHG
0
2

4
TXT
0
0