How to combine a request?

Question

PHP

There is a request like this:

SELECT sum(money) FROM `accounts` WHERE date >= CURDATE() AND tel_id = 1234 AND type = 1 AND status = 1

And like this:

SELECT sum(money) FROM `accounts` WHERE date >= CURDATE() AND tel_id IN (1542, 6624, 2524) AND type = 1 AND status = 1

How to combine these queries so that the result is:
--------------------------
| tel_id | sum1 | sum2 |
--------------------------

Answer 1

SELECT T1.tel_id, T1.sum1, T2.sum2
FROM
  (SELECT tel_id, sum(money) AS sum1
   FROM accounts
   WHERE date >= CURDATE() AND tel_id = 1234 AND type = 1 AND status = 1
   ) T1,
  (SELECT tel_id, sum(money) AS sum2
   FROM accounts
   WHERE date >= CURDATE() AND tel_id IN (1542, 6624, 2524) AND type = 1 AND status = 1
  ) T2
WHERE T2.tel_id = T1.tel_id

Answer 2

You don't need to merge anything, joining tables on itself is bad practice and slow queries. It makes no sense, there will be no gain in speed, and the logic of the request through the fifth point. Make 2 requests and combine data in php, then everything will work quickly and logically. Use KISS.