Stuff

SELECT user_id, user_name, COUNT(*) AS actions_count FROM users_action JOIN users ON users_action.user_id = users.id WHERE users.role = 1 AND type_id = 0 AND act_date > MAKEDATE(YEAR(CURDATE()), MONTH(CURDATE())) AND mt_id IN (SELECT id FROM main_table WHERE status = 1) GROUP BY user_id