title: Create nested json object using php mysql
body: <p>I have two tables, table 1 has 2 fields (question_pk, question_name) and table 2 has 4 fields(ans_pk, options, question_fk and right_answer). <strong>I want to create json like the following structure</strong></p>
  
  <pre><code>{
      "type": "quiz",
      "name": "Brand Colors",
      "description": "Can you identify these brands by the background color?",
      "questions": [
          {
              "name": "Can you identify this color?",
              "description": "#ea4c89",
              "answers": [
                  {
                      "name": "Dribbble",
                      "description": "dribbble.png",
                      "weight": 1
                  },
                  {
                      "name": "Amazon",
                      "description": "amazon.png",
                      "weight": 0
                  },
                  {
                      "name": "Apple",
                      "description": "apple.png",
                      "weight": 0
                  }
              ]
          },
          {
              "name": "Can you identify this color?",
              "description": "#3d9ae8",
              "answers": [
                  {
                      "name": "Youtube",
                      "description": "youtube.png",
                      "weight": 0
                  },
                  {
                      "name": "Dropbox",
                      "description": "dropbox.png",
                      "weight": 1
                  },
                  {
                      "name": "Wordpress",
                      "description": "wordpress.png",
                      "weight": 0
                  }
              ]
          },
          {
              "name": "Can you identify this color?",
              "description": "#c4302b",
              "answers": [
                  {
                      "name": "Youtube",
                      "description": "youtube.png",
                      "weight": 1
                  },
                  {
                      "name": "Twitter",
                      "description": "twitter.png",
                      "weight": 0
                  },
                  {
                      "name": "Vimeo",
                      "description": "vimeo.png",
                      "weight": 0
                  }
              ]
          }
  
      ]
  }
  </code></pre>
  
  <p>MY PHP CODE</p>
  
  <pre><code>&lt;?php
  include '../config/config.php';
  if(isset($_GET['sub_cat_id']))
  {
           $sub_cat_id = $_GET['sub_cat_id']; 
          $result = mysql_query("select * from $questions where sub_cat='$sub_cat_id' order by level_fk asc"); 
          $json_response = array(); //Create an array
          $i=1;
                          while ($row = mysql_fetch_array($result))
                          {
                          $row_array['qus_pk'] = $row['qus_pk'];        
                          $row_array['question'] = $row['question'];
                          $qus_pk = $row['qus_pk'];  
  
  
                          $option_qry = mysql_query("select * from $qus_ans where qus_pk=$qus_pk");
                          while ($opt_fet = mysql_fetch_array($option_qry))
                          {
  
                          $row_array['options'] = $opt_fet['options'];  
                          $row_array['right_ans'] = $opt_fet['right_ans'];  
                          array_push($json_response,$row_array); //push the values in the array
                              }                       
  
  
                          $i++;
                          }
          echo json_encode($json_response);
  }
  
  ?&gt;
  </code></pre>
  
  <p>And My Result I am getting json response like the following</p>
  
  <pre><code>[
      {
          "qus_pk": "1",
          "question": "Ten years ago, P was half of Q in age. If the ratio of their present ages is 3:4, what will be the total of their present ages?",
          "options": "45",
          "right_ans": "0"
      },
      {
          "qus_pk": "1",
          "question": "Ten years ago, P was half of Q in age. If the ratio of their present ages is 3:4, what will be the total of their present ages?",
          "options": "40",
          "right_ans": "0"
      },
      {
          "qus_pk": "1",
          "question": "Ten years ago, P was half of Q in age. If the ratio of their present ages is 3:4, what will be the total of their present ages?",
          "options": "35",
          "right_ans": "1"
      },
      {
          "qus_pk": "1",
          "question": "Ten years ago, P was half of Q in age. If the ratio of their present ages is 3:4, what will be the total of their present ages?",
          "options": "50",
          "right_ans": "0"
      },
      {
          "qus_pk": "2",
          "question": "Father is aged three times more than his son Sunil. After 8 years, he would be two and a half times of Sunil's age. After further 8 years, how many times would he be of Sunil's age?",
          "options": "4 times",
          "right_ans": "0"
      },
      {
          "qus_pk": "2",
          "question": "Father is aged three times more than his son Sunil. After 8 years, he would be two and a half times of Sunil's age. After further 8 years, how many times would he be of Sunil's age?",
          "options": "1 times",
          "right_ans": "0"
      },
      {
          "qus_pk": "2",
          "question": "Father is aged three times more than his son Sunil. After 8 years, he would be two and a half times of Sunil's age. After further 8 years, how many times would he be of Sunil's age?",
          "options": "3 times",
          "right_ans": "1"
      },
      {
          "qus_pk": "2",
          "question": "Father is aged three times more than his son Sunil. After 8 years, he would be two and a half times of Sunil's age. After further 8 years, how many times would he be of Sunil's age?",
          "options": "5 times",
          "right_ans": "0"
      }
  ]
  </code></pre>
  
  <p>In my respose each time the question is repeated so how to avoid and <strong>if i want to achive the first json structure,</strong> in my PHP code what&amp;where i need to make changes?. If any one knows help me.</p>