SELECT from "vertical" table and display on "horizontal" table
You can use conditional aggregation to get the expected result set:

SELECT cityID, 
       MAX(CASE WHEN parameterID = 1 THEN value END) AS temp,
       MAX(CASE WHEN parameterID = 2 THEN value END) AS humidity,
       MAX(CASE WHEN parameterID = 3 THEN value END) AS rain
FROM mytable
GROUP BY cityID


Demo here