How to create a new table from an existing one in PHP?

Question

PHP

Good afternoon.
There is a tabular selection from the database of the following form:

ID	post_id	meta_key	meta_value
one	645	meta_key_1	"habrakadabra"
2	508	meta_key_1	"opa"
3	645	meta_key_2	"priznak"
4	508	meta_key_2	"dasdasdasd"

Suppose we have already parsed it using foreach. It is required to create a new table using a php query in such a way that for all rows whose post_ids match, all their meta_values ​​for the corresponding meta_keys appear in one row. I.e:

ID	post_id	meta_value_of_meta_key_1	meta_value_of_meta_key_2
one	645	"habrakadabra"	"priznak"
2	508	"opa"	"dasdasdasd"

This is real :) ?

Answer 1

Please prove that you know what you are doing by breaking the normal form of the database (normal form is a technical term). Those. a clear argument as to why it should be done that way.
Then I will post the solution.