SQL QUERY, HOW USE UNION OPERATOR

See more:

SQL

MySQL

Hello! I have some tables, from that i want display all rows for using operator UNION.
My simple SQL query is:

SELECT idTYPEORDER, TYPEORDERNAME FROM typeorder AS TYPEORDER UNION
           SELECT idTYPE, TYPENAME FROM type_estate AS TYPEESTATE UNION
           SELECT idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME FROM apartament_flats AS APARTAMENT_FLATS UNION
           SELECT idCURRENCY, CURRENCYNAME FROM currency AS CURRENCY UNION
           SELECT idCOUNTRY, COUNTRYNAME FROM country AS COUNTRY UNION
           SELECT idREGION, REGIONNAME FROM region AS REGION UNION
           SELECT idCITY, CITYNAME FROM city   AS CITY UNION
           SELECT idPOSITION, POSITIONNAME FROM position AS POSITION

I got result:

array(24) {
  [0]=>
  object(stdClass)#19 (2) {
    ["idTYPEORDER"]=>
    string(1) "1"
    ["TYPEORDERNAME"]=>
    string(12) "Купить"
  }
  [1]=>
  object(stdClass)#20 (2) {
    ["idTYPEORDER"]=>
    string(1) "2"
    ["TYPEORDERNAME"]=>
    string(10) "Снять"
  }
  [2]=>
  object(stdClass)#21 (2) {
    ["idTYPEORDER"]=>
    string(1) "1"
    ["TYPEORDERNAME"]=>
    string(16) "Квартира"
  }
  [3]=>
  object(stdClass)#22 (2) {
    ["idTYPEORDER"]=>
    string(1) "2"
    ["TYPEORDERNAME"]=>
    string(6) "Дом"
  }
  [4]=>
  object(stdClass)#23 (2) {
    ["idTYPEORDER"]=>
    string(1) "4"
    ["TYPEORDERNAME"]=>
    string(10) "Вилла"
  }
  [5]=>
  object(stdClass)#24 (2) {
    ["idTYPEORDER"]=>
    string(1) "5"
    ["TYPEORDERNAME"]=>
    string(12) "Студия"
  }
  [6]=>
  object(stdClass)#25 (2) {
    ["idTYPEORDER"]=>
    string(1) "1"
    ["TYPEORDERNAME"]=>
    string(20) "1-комнатные"
  }
  [7]=>....

How i can modify query, that output will be array with keys CURRENCY UNION, COUNTRY, REGION etc. and element this massive would be ID, NAME of columns?