title: How can I do a join on two JSON objects?
body: <p>It is possible to join on PHP two JSONs on two different columns name (id&lt;->lid)? JSONs looks like that:
  <pre><code>
  [{"id":504,"displayname":"Jack","idname":"Work"},{"id":505,"displayname":"Peter","idname":"Home"}]
  [{"id":12,"role_id":1800,"prv":2,"lid":504},{"id":20,"role_id":1800,"prv":2,"lid":505}]
  </pre></code></p>
  
  <p>Ouput should looke like this:
  <pre><code>
  [{"id":504,"displayname":"Jack","idname":"Work","id":12,"role_id":1800,"prv":2,"lid":504},{"id":505,"displayname":"Peter","idname":"Home","id":20,"role_id":1800,"prv":2,"lid":505}]
  </pre></code></p>
  
  <p>Thanks in advance for help.</p>