How to output data from json sorting output by only one field?

Question

MySQL

So, there is a json file, something like this:

{
    "games": [
        {
            "name": "FlatOut 2",
            "image": "http:\/\/www.game-ost.ru\/static\/covers_soundtracks\/1\/1\/11195_599433.jpg",
            "game_key": "DNVI5-74JHP-OLOQ2",
            "start": 1441052980,
            "winner": "https:\/\/vk.com\/id164746581"
        },
        {
            "name": "Anachronox",
            "image": "http:\/\/www.abcgames.sk\/udaje\/cd_obaly\/2\/230_f1.jpg",
            "game_key": "GPXFT-J9GJ4-PF58L",
            "start": 1441114401
        },
        {
            "name": "Daikatana",
            "image": "http:\/\/files.khinsider.com\/vgwallpaper\/1280x1024\/685-daikatana-005-wywlf.jpg",
            "game_key": "GPXFT-J9GJ4-PF58L"
        }
    ]
}

I need to display only the data that contains the winner string.
Essence - there is a competition for the selection of the key to the game. The game is selected first in the json file list. If the key is matched, the winner string is assigned to the array, and the next string is selected, where there is no winner string. The tuba is written with the line start and the contest is started in a new way.
I want to make a file that will output "winning history". That is, it will indicate which games were played, when, what was the key and who won.
I didn't write the system. In programming, I do not understand even the lines.
Can you help with writing a handler?

Answer 1

https://dev.mysql.com/doc/refman/5.7/en/view-restr...

Before MySQL 5.7.7, subqueries cannot be used in the FROM clause of a view.

Answer 2

because views cannot have a subquery in the FROM part of the
emnip, in recent versions there is no such restriction

Answer 3

$json = '{
  "games": [
    {
      "name": "FlatOut 2",
      "image": "http:\/\/www.game-ost.ru\/static\/covers_soundtracks\/1\/1\/11195_599433.jpg",
      "game_key": "DNVI5-74JHP-OLOQ2",
      "start": 1441052980,
      "winner": "https:\/\/vk.com\/id164746581"
    },
    {
      "name": "Anachronox",
      "image": "http:\/\/www.abcgames.sk\/udaje\/cd_obaly\/2\/230_f1.jpg",
      "game_key": "GPXFT-J9GJ4-PF58L",
      "start": 1441114401
    },
    {
      "name": "Daikatana",
      "image": "http:\/\/files.khinsider.com\/vgwallpaper\/1280x1024\/685-daikatana-005-wywlf.jpg",
      "game_key": "GPXFT-J9GJ4-PF58L"
    }
  ]
}';


  $data = json_decode($json, true);

  foreach ($data['games'] as $game)
  {
    if (isset($game['winner']))
    {
      //выводим
      print $game['name'] . "<br>";
    }
  }