MySQL architecture for different word clouds
CREATE TABLE words (
    user_type ENUM('anonymous', 'users', 'organizations') NOT NULL,
    group_id SMALLINT UNSIGNED NOT NULL,
    word VARCHAR(...) NOT NULL,
    ct MEDIUM INT UNSIGNED NOT NULL,   -- how often user used the word
    PRIMARY KEY(user_type, user_id, word)
) ENGINE=InnoDB;


This will let you build an overall cloud, or a cloud for an individual user/organization.

SELECT word, SUM(ct) FROM words;  -- overall

SELECT word, ct
    FROM words
    WHERE user_type = 'organization'
      AND group_id = 123   -- for a particular user


You have not really mentioned a requirement any date.