Get a SELECT result with column comments

I have various tables with data that have important comments on the columns. I want to get a SELECT result not only with column names in the header, but also with comments.

column_name1|column_name2|...
column_comment1|column_comment2|...
column_data1(1)|column_data2(1)|...
column_data1(2)|column_data2(2)|...
column_data1(i)|column_data2(i)|...
.
.
.

I tried to extract comments like...

SELECT column_comment FROM `information_schema`.`COLUMNS` as columns
    WHERE
        table_name = 'mytable'

but found no way to transpose the results into columns for subsequent
UNION with SELECT * FROM mytable data

UPDATE
I have a table mytable

+------+-------+--------------------------------------+
| id   | name  | address                              |
+------+-------+--------------------------------------+
| 1    | John  | ...                                  |
| 2    | Lissy | ...                                  |
| 3    | Elis  | ...                                  |
| 4    | Jack  | ...                                  |
+------+-------+--------------------------------------+

Columns have comments:

CREATE TABLE `mytable` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) unsigned DEFAULT NULL COMMENT 'a name comment',
  `date` varchar(500) DEFAULT NULL COMMENT 'an address comment',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`))

I want to see something like:

+------+-----------------+--------------------------------------+
| id   | name            | address                              |
+------+-----------------+--------------------------------------+
|      | a name comment  | an address comment                   |
+------+-----------------+--------------------------------------+
| 1    | John            | ...                                  |
| 2    | Lissy           | ...                                  |
| 3    | Elis            | ...                                  |
| 4    | Jack            | ...                                  |
+------+-----------------+--------------------------------------+

I guess you may use below dynamic query -

set @sql = null;
SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'max(case when column_name = ''',
      column_name,
      ''' then column_comment end) as ', 
      column_name)
  )  into @sql
FROM
(
  select column_name
  FROM `information_schema`.`COLUMNS` as columns
    WHERE table_name = 'T'
)d;

SET @sql = CONCAT('SELECT ',  @sql, ' FROM information_schema.COLUMNS WHERE table_name = ''T'' union all select * from T');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Here is the fiddle.