+----+-----+--------+--------+
| id | mac | region | status |
+----+-----+--------+--------+
|  1 | ab  |      0 |      0 |
|  2 | ba  |      1 |      1 |
|  3 | ac  |      3 |      0 |
|  4 | ca  |      1 |      2 |
|  5 | fg  |      0 |      2 |
|  6 | fr  |      0 |      0 |
|  7 | tr  |      0 |      0 |
|  8 | tr  |      3 |      0 |
+----+-----+--------+--------+

+----+-----+------+-------+-------------------------------------------------------------------------+
| id | mac | reg1 | stat1 | (select count(status) from hardware where stat1=status and reg1=region) |
+----+-----+------+-------+-------------------------------------------------------------------------+
|  1 | ab  |    0 |     0 |                                                                       3 |
|  3 | ac  |    3 |     0 |                                                                       2 |
|  2 | ba  |    1 |     1 |                                                                       1 |
|  5 | fg  |    0 |     2 |                                                                       1 |
|  4 | ca  |    1 |     2 |                                                                       1 |
+----+-----+------+-------+-------------------------------------------------------------------------+

select id,mac,region as reg1, status as stat1,(select count(status) from hardware where stat1=status and reg1=region)  from hardware group by region,status order by status,region ;