SELECT
a.age,b.addres
DATE_FORMAT(a.creatime,'%Y-%c-%d %h:%i:%s') as creatime,
DATE_FORMAT(b.creatime,'%Y-%c-%d %h:%i:%s') as next_creatime,
case
when
a.status = '00' then '是' else '否' end as status,
case
when b.status = '0' then '否' else '是' end as status
FROM
user a
LEFT JOIN user_info b ON a.id = b.user_id
order by a.id desc limit 0,10
a.age,b.addres
DATE_FORMAT(a.creatime,'%Y-%c-%d %h:%i:%s') as creatime,
DATE_FORMAT(b.creatime,'%Y-%c-%d %h:%i:%s') as next_creatime,
case
when
a.status = '00' then '是' else '否' end as status,
case
when b.status = '0' then '否' else '是' end as status
FROM
user a
LEFT JOIN user_info b ON a.id = b.user_id
order by a.id desc limit 0,10