title: Laravel get user today and tomorrow birthday
body: <p>I have this query to get tomorrow and today birthday users:</p>
  
  <pre><code>$birthday[Carbon::now()-&gt;format('Y-m-d')] = User::whereRaw("DATE_FORMAT(birthday, '%m-%d') = DATE_FORMAT(now(),'%m-%d')")
          -&gt;orWhereRaw("DATE_FORMAT(birthday,'%m-%d') = '02-29' and DATE_FORMAT(birthday, '%m') = '02' AND 
          LAST_DAY(NOW()) = DATE(NOW())")
          -&gt;selectRaw('first_name, last_name, email, birthday')
          -&gt;get();
  
  $birthday[Carbon::now()-&gt;addDay()-&gt;format('Y-m-d')] = User::whereRaw("DATE_FORMAT(birthday, '%m-%d') = DATE_FORMAT(NOW() + INTERVAL 1 DAY, '%m-%d')")
          -&gt;orWhereRaw("DATE_FORMAT(birthday,'%m-%d') = '02-29' and DATE_FORMAT(birthday, '%m') = '02' AND 
              LAST_DAY(NOW()) = DATE(NOW())")
          -&gt;selectRaw('first_name, last_name, email, birthday')
          -&gt;get();
  
   return $birthday;
  </code></pre>
  
  <p>The query will give me this result:</p>
  
  <pre><code>{
      "2016-03-30": [
          {
            "first_name": "Harmon",
            "last_name": "Olson",
            "email": "GleasonSwaniawski.Jeanne@yahoo.com",
            "birthday": "1990-03-30"
          },
          {
            "first_name": "John",
            "last_name": "Doe",
            "email": "john.doe@yahoo.com",
            "birthday": "1990-03-30"
          },
      ],
      "2016-03-31": [
          {
            "first_name": "User10",
            "last_name": null,
            "email": "user10@user.com",
            "birthday": "1990-03-31"
          }
      ]
  }
  </code></pre>
  
  <p>Sure it worked properly and the result exactly what I wanted, But I think my query can be shorten (combine the query become one) to get what I want achieve.</p>
  
  <p>Any advice how to shorten it?</p>
  
  <p>Thanks in advance!</p>