DELIMITER ;;

SET @i = 5;
DROP TABLE IF EXISTS items;
CREATE TEMPORARY TABLE items(lmonth DATE, total INT);

SET @loop_date = DATE_FORMAT(CURRENT_DATE(), '%Y-%c-01');

WHILE(@i > 0) DO

    SET @loop_date = DATE_SUB(@loop_date, INTERVAL 1 MONTH);

    SELECT DISTINCT COUNT(Users.id) INTO @RESULT
    FROM gestcab_users AS Users
    LEFT JOIN gestcab_roles AS Roles ON Users.role_id = Roles.id
    WHERE Roles.slug = 'patient'
    AND DATE(Users.created) < @loop_date AND
    DATE(Users.created) >= DATE_SUB(@loop_date, INTERVAL 1 MONTH);

    INSERT INTO items(lmonth, total) VALUES(@loop_date, @RESULT);

    SET @i = @i - 1;

END WHILE;

SELECT (*) items;
;;