Make 3 paired columns from one Mysql

I have a problem with a query that I try to make over a table in database.

So my table has a column with names like this :

I want a query that will select names and ids in the following mode:

either

or

Thanks in advance...