DELIMITER ;;
BEGIN
SET @i = 5;
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;
END;;