select mg.* from member_gold mg
(
select DISTINCT(mg.memberid), MAX(mg.createtime) createtime from member_gold mg group by mg.memberid order by mg.createtime desc
) mgresult
on mgresult.memberid = mg.memberid
and mg.createtime = mgresult.createtime