select * from 表 where id in (select max(id) from 表 group by 去重字段 )
eg:
select * from planthr_info where id in (select max(id) from planthr_info group by name)
select * from 表 where id in (select max(id) from 表 group by 去重字段 )
select * from planthr_info where id in (select max(id) from planthr_info group by name)