title: Getting top cloners in my Database?
body: <p>I wondered if anyone could at least help me find where to start with this. I understand its a large question but I have looked for a while and I can't find anything related to how to do with this two columns.</p>
  
  <p>I have a table called 'users', I want to select the top 20 with the most cloned accounts. When I say cloned accounts, I mean that I want to show a list of user's usernames who have the most accounts with the same IP or Machine ID.</p>
  
  <p>The IP column is called ip_last and the machine column is called machine_id. </p>
  
  <p>How would I go about getting the top 20 with the most cloned accounts? All I want to display is the username, how many accounts cloned by IP, and how many accounts cloned by Machine.</p>
  
  <p>Id accept knowing how to do this in MySQL, but if someone could help me get it working with Laravel then that would also help a lot.</p>