title: How to write a multi table query with MySQL?
body: <p>i have two tables consume and recharge. how can i get the result? </p>
  
  <p>consume table           </p>
  
  <pre><code>user_name   date                consume 
  a          12/12/2018 12:20       10    
  a          12/12/2018 12:20       12    
  a          1/1/2019 11:00         13    
  </code></pre>
  
  <p>recharge table          </p>
  
  <pre><code>user_name   date                recharge    
  a          12/12/2018 12:20       20    
  a          12/12/2018 12:20       30    
  a          1/1/2019 11:00         40    
  </code></pre>
  
  <p>result  </p>
  
  <pre><code>user_name   date                  consume   recharge
  a           12/12/2018 12:20        22        50
  a           1/4/2019 12:20          13        40
  </code></pre>