SELECT `dp_cms_service`.*,`admin_user`.`username` FROM `dp_cms_service` LEFT JOIN `dp_admin_user` `admin_user` ON `dp_cms_service`.`uid`=`admin_user`.`id` WHERE `dp_cms_service`.`trash` = 0 AND `dp_cms_service`.`status` = 1 AND `dp_cms_service`.`cid` IN (13) ORDER BY `create_time` DESC LIMIT 0,20