Fetch JSON file as sql in php

I have the this code to fetch data from JSON file as SQL, in order fetch it by date.

PHP file:

$sql = "SELECT from 'd.json' WHERE ORDER BY post_date LIMIT 10";
while($rows = mysqli_fetch_assoc($sql)) {
    echo {$rows[post_text]};
}

JSON file:

{
"1011151247779348480": {
    "id": "1011151247779348480",
    "name": "infires",
    "tweet_url": "https:\/\/twitter.com\/yeonkimin_09\/status\/1011151247779348480",
    "post_date": "Mon Jun 25 07:36:58 +0000 2018",
    "post_text": "RT @savantyoongi: they may be the family of savageness but yoongi\u2019s family love him so much. whether he\u2019s famous or not, they love him with\u2026",
    "avatar": "https:\/\/pbs.twimg.com\/profile_images\/1005757319647354881\/ltnID8te_normal.jpg",
    "post_device": "<a href=\"http:\/\/twitter.com\/download\/android\" rel=\"nofollow\">Twitter for Android<\/a>",
    "location": "",
    "user_followers_count": 9,
    "user_created_at": "Mon Jan 08 07:38:37 +0000 2018",
    "user_screen_name": "yeonkimin_09"
},
"1011151247745978368": {
    "id": "1011151247745978368",
    "name": "Popcorn Outdoor",
    "tweet_url": "https:\/\/twitter.com\/PopcornOutdoor\/status\/1011151247745978368",
    "post_date": "Mon Jun 25 07:36:58 +0000 2018",
    "post_text": "RT @slowreadersclub: Nothing but love what ever happens \u2764\ufe0f https:\/\/t.co\/1CQGH4xcig",
    "avatar": "https:\/\/pbs.twimg.com\/profile_images\/684682001945866240\/vECXWPiC_normal.png",
    "post_device": "<a href=\"http:\/\/twitter.com\" rel=\"nofollow\">Twitter Web Client<\/a>",
    "location": "UK",
    "user_followers_count": 482,
    "user_created_at": "Wed Jun 20 13:31:38 +0000 2012",
    "user_screen_name": "PopcornOutdoor"
},
}

but it didn't work, any idea?