just a sql

select b.name,n.remark,b.login from
(select distinct t.name,count(t.name) login from ifmis_t_userlogin t  group by t.name order by login desc) b
left join t_causer n on b.name=n.code