我想：
选择所有标记（从标记表）
具有名为selected的虚拟列
包含布尔值的。0 || 1)
它定义标记标识是否与给定的图像标识相关联
（是的。图像（id=1）
关系数据集，它被预置在一个名为image\u tag的透视表中
结构和数据：

CREATE TABLE IF NOT EXISTS `images` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `images` (`id`, `title`) VALUES
(1, 'Image 1'),
(2, 'Image 2');

CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tags_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tags` (`id`, `name`) VALUES
(1, 'Tag A'),
(2, 'Tag B'),
(3, 'Tag C'),
(4, 'Tag D');

/* Pivot table */
CREATE TABLE IF NOT EXISTS `image_tag` (
  `image_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`image_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `image_tag` (`image_id`, `tag_id`) VALUES
(1, 1),
(1, 2),
(2, 1),
(2, 3);

SELECT * FROM images;
/*
+----+---------+
| id | title   |
+----+---------+
|  1 | Image 1 |
|  2 | Image 2 |
+----+---------+

* /

SELECT * FROM tags;
/*
+----+-------+
| id | name  |
+----+-------+
|  1 | Tag A |
|  2 | Tag B |
|  3 | Tag C |
|  4 | Tag D |
+----+-------+

* /

SELECT * FROM image_tag;
/*
+----------+--------+
| image_id | tag_id |
+----------+--------+
|        1 |      1 |
|        1 |      2 |
|        2 |      1 |
|        2 |      3 |
+----------+--------+

* /

我想要的结果是：

/*
+----+-------+----------+
| id | tag   | selected |
+----+-------+----------+
|  1 | Tag A | 1        |
|  2 | Tag B | 1        |
|  3 | Tag C | 0        |
|  4 | Tag D | 0        |
+----+-------+----------+

* /

感谢您的帮助：）