title: Multiple rows.Next() in the same time golang sql/database
body: <p>I am working on a function which gets users. My problem is that I have to return the result of two queries as one result in the <code>rows.Next()</code> and <code>rows1.Next()</code> like <code>user_id</code>, <code>subject</code>, <code>phone</code>.</p>
  
  <p>Here is what I have but it doesn't work. Could you please help me out with some suggestions:</p>
  
  <pre><code>func GetUsers() (users []Users, err error) {
  
      users = make([]Users, 0)
      rows, err := db1.Query("SELECT  user_id, subject,phone FROM users limit 11")
      rows1, err := db1.Query("Select body from users limit 11")
      defer rows.Close()
      if err != nil {
          // handle this error better than this
          log.Fatal(err)
          //return
      }
      var user Users
      for rows.Next() {
          rows.Scan(&amp;user.ID, &amp;user.Subject, &amp;user.Phone)
          users = append(users, user)
      }
      for rows1.Next() {
  
          rows1.Scan(&amp;user.Body)
          users = append(users, user)
  
      }
      return 
  }
  </code></pre>
  
  <p>I have a table called <code>users</code> which has no primary key, basically:</p>
  
  <pre><code>user_id . name  . body 
  -----------------------
  1       . model . 2
  1       . brand . 1
  1       . fuel  . 3
  1       . date  . 1
  1       . year  . 1
  </code></pre>
  
  <p>I have to have a result:</p>
  
  <pre><code>userid . model . brand . fuel . date . year 
  1      . 2     . 1     . 3    . 1    . 1
  </code></pre>
  
  <p>so the values in the column name gonna be as rows. I have already defined my struct which contains all the fields needed.</p>