select * from `imgtitle`, `imginfo` where `imgtitle`.`id`=`miaoshu`.`fid` group by `miaoshu`.`fid` ORDER BY `imgtitle`.`id` DESC LIMIT 10
SELECT a. id , a.title, a.time, b.miaoshu FROM `imgtitle` a inner join ( SELECT ` fid `,`miaoshu` from `imginfo` group by fid ) b on a.id=b.fid ORDER BY a.id DESC LIMIT 10
inner join
(
SELECT ` fid `,`miaoshu` from `imginfo` group by fid
) b
on a.id=b.fid ORDER BY a.id DESC LIMIT 10