MySQL Subquery: SELECT notation like [items ids="74,73,72,58"] and SELECT ids values into another table

Hope the answer is clear: i would like to SELECT from a table, values 74,73,72,58: but to get these values that are contained into another table inside a notation like this: [items ids="74,73,72,58"] how i should do?

Example: Into a table, a column value contain exactly this:

[items ids="74,73,72,58"]

so in the same single query, i would like to SELECT IDs 74,73,72,58 that are contained into another table. Is this possible to be achieved with a single query, using a subselect? How?

In other "words" example: SELECT FROM t1 (on t1 the column row contain this) [items ids="74,73,72,58"] then i would like to SELECT ON t2 VALUES 74,73,72,58

p.s how this kind of notation is named (if is named)? [items ids="2,3,7,9"]