title: Mysql get current count till result
body: <p>This is my data set:</p>
  
  <pre><code>id  user_id amount  added   
  1   1   10.00   2018-09-11  
  2   2   10.00   2018-09-12
  3   3   10.00   2018-09-13
  4   1   8.00    2018-09-14
  5   2   6.00    2018-09-15
  </code></pre>
  
  <p>What I need is a query to produce the following result:</p>
  
  <pre><code>id  user_id amount  added   status
  1   1   10.00   2018-09-11  new
  2   2   10.00   2018-09-12  new
  3   3   10.00   2018-09-13  new
  4   1   8.00    2018-09-14  recurring
  5   2   6.00    2018-09-15  recurring
  </code></pre>
  
  <p>I want to get status of user id either previous it occurred or not. If not than show <code>new</code> else <code>recurring</code>.</p>