mysql> CREATE TABLE chepuxa (
    ->     id INT AUTO_INCREMENT,
    ->     ad_id INT,
    ->     year INT,
    ->     month INT,
    ->     day INT,
    ->     status VARCHAR(10),
    ->     payout INT,
    ->     PRIMARY KEY (id)
    -> ) ENGINE=INNODB;
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO chepuxa (ad_id, year, month, day, status, payout)
    -> VALUES 
    ->     (123, 2019, 2, 1, 'approved', 500),
    ->     (123, 2019, 2, 1, 'declined', 0),
    ->     (123, 2019, 2, 1, 'wait', 0),
    ->     (123, 2019, 2, 1, 'approved', 500),
    ->     (123, 2019, 2, 1, 'declined', 0),
    ->     (222, 2019, 2, 1, 'approved', 500),
    ->     (222, 2019, 2, 1, 'declined', 0),
    ->     (222, 2019, 2, 1, 'declined', 0),
    ->     (222, 2019, 2, 1, 'approved', 500);
Query OK, 9 rows affected (0.11 sec)
Records: 9  Duplicates: 0  Warnings: 0

mysql> SELECT 
    ->     ad_id,
    ->     year,
    ->     month,
    ->     day,
    ->     SUM(IF(status='approved', 1, 0)) AS approved,
    ->     SUM(IF(status='declined', 1, 0)) AS declined,
    ->     SUM(IF(status='wait', 1, 0))     AS wait,
    ->     SUM(payout)                      AS payout
    -> FROM chepuxa
    -> GROUP BY ad_id, year, month, day;
+-------+------+-------+------+----------+----------+------+--------+
| ad_id | year | month | day  | approved | declined | wait | payout |
+-------+------+-------+------+----------+----------+------+--------+
|   123 | 2019 |     2 |    1 |        2 |        2 |    1 |   1000 |
|   222 | 2019 |     2 |    1 |        2 |        2 |    0 |   1000 |
+-------+------+-------+------+----------+----------+------+--------+
2 rows in set (0.01 sec)