MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE user(
                  id         INT NOT NULL AUTO_INCREMENT, 
                  name       VARCHAR(100) NOT NULL, 
                  parameters LONGTEXT,  
                  PRIMARY KEY(id)
                  )
INSERT INTO user VALUES 
(1, 'name1', '{"number": 1, "text": "some text"}'), 
(2, 'name2', '{"number": 2, "text": "some more text"}')
SELECT CONCAT(
       '[',
        GROUP_CONCAT(JSON_OBJECT('id',id,
                                 'name',name,'parameters', 
                                  JSON_COMPACT(parameters))),
       ']'
       ) AS "JSON Value"
  FROM user


JSON Value


[{"id": 1, "name": "name1", "parameters": {"number": 1, "text": "some text"}},{"id": 2, "name": "name2", "parameters": {"number": 2, "text": "some more text"}}]