Есть два запроса
SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= CURDATE( )
SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
Возможно их объединить?
SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= CURDATE( )
SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= CURDATE( ) OR time >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
select
(SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= CURDATE( ) ) as count_date,
(SELECT count(DISTINCT `ip`) visit FROM `actionsUser` WHERE time >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH) ) as count_month