How to build a sql query?

Question

MySQL

Good afternoon!
There is a table in the database:

How to write a query so that an array with the latest records (that is, the maximum id ) is returned, but the values ​​​​in the uid column are not repeated.
At the output you need something like this:

array(2) {
  [0]=>
  array(2) {
    ["uid"]=>
    string(2) "10"    
   ["text"]=>
    string(2) "айяйяй"
  }
  [1]=>
  array(2) {
    ["uid"]=>
    string(2) "11"    
   ["text"]=>
    string(2) "бебебе"
  }
}

Answer 1

select * from table group by uid order by id desc limit 2

Answer 2

Choose the maximum id grouped by uid and join the table by id to this selection

Answer 3

select uid, text from (select uid, max(id) from `table` group by uid) tmp 
join `table` on tmp.uid = table.uid