There are 3 types of bar-charts to show according to the structure SQL result:

1. show chart - data horizontal: columns are x-axis

Use your existing user table, and only import user_id in to blog_cat.cat = 1001 eg

REPLACE INTO blog_cat(cat,name,info) VALUES
(1001,'blog_staff','{"1":[1,2],"181130":[102,108]}');

staff user id is a json of: catetory and user ids, above means:

cat = 1 (all categories i.e. Admin staff)
user_id = 1, 2

cat = 181130 (i.e. staff or moderators for cat = 181130)
user_id = 102, 108 etc

There are basic blog admin tools available (not copied back from previous version yet) via:

at the bottom of editing any topic page:

* Update Created: ?ajax=created&val=2018-12-25 12:34:56
* Unlock: ?ajax=unlock&val=x (login only)
* Update Meta: ?ajax=ext_url&val=www.abc.com
* Update Meta:

Default blog will use Topnew MVC and it is using /css/2018.css, 2019.js

However you can overwrite via /blog/blog.css, blog.js

And you can also change view files at: /var/www/app/View/Blog/cat.blade.php, home.blade.php etc

OR you can even make it look totally different via: /blog/index.php:

This table holds all category id (cat) and category name (name or url) and category info (displayed as text)

eg name = news-media
if info = '', info will auto displayed as News Media. So if you want to display something else, you need input here.

cat id 1 .. 99 is reserved for system uses.