MySQL JSON_OBJECTAGG

You must execute the code again to save those values in the database.

CREATE TABLE Posts (
  PostId INT AUTO_INCREMENT KEY,
  PostTitle VARCHAR(255),
  PostSummary VARCHAR(255)
);

INSERT INTO Posts(PostTitle, PostSummary) VALUES ('Title 1', 'Summary 1');
INSERT INTO Posts(PostTitle, PostSummary) VALUES ('Title 2', 'Summary 2');
INSERT INTO Posts(PostTitle, PostSummary) VALUES ('Title 3', 'Summary 3');

CREATE TABLE Tags (
  TagId INT AUTO_INCREMENT KEY,
  TagName VARCHAR(255),
  TagSlug VARCHAR(255)
);

INSERT INTO Tags(TagName, TagSlug) VALUES ('tag name 1', 'tag-name-1');
INSERT INTO Tags(TagName, TagSlug) VALUES ('tag name 2', 'tag-name-2');
INSERT INTO Tags(TagName, TagSlug) VALUES ('tag name 3', 'tag-name-3');

CREATE TABLE TagsMap (
  PostId INT,
  TagId INT
);

INSERT INTO TagsMap(PostId, TagId) VALUES (1,1);
INSERT INTO TagsMap(PostId, TagId) VALUES (1,2);
INSERT INTO TagsMap(PostId, TagId) VALUES (2,2);

SELECT PostId, PostTitle, PostSummary,
  (SELECT JSON_OBJECTAGG(t.TagSlug, t.TagName)
   FROM TagsMap tm
   JOIN Tags t ON tm.TagId = t.TagId
   WHERE tm.PostId = p.PostId
  ) TagsObject
FROM Posts p
ORDER BY PostId DESC LIMIT 10;

PostId	PostTitle	PostSummary	TagsObject
3	Title 3	Summary 3	NULL
2	Title 2	Summary 2	{"tag-name-2": "tag name 2"}
1	Title 1	Summary 1	{"tag-name-1": "tag name 1", "tag-name-2": "tag name 2"}