SELECT p.id, p.name, p.projectid, p.userid, p.statu,
(SELECT COUNT(*) FROM model m WHERE p.`name`=m.`name` AND DATE_FORMAT(m.addtime,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m') AND m.`projectid` = 1) AS `adds`,
(SELECT COUNT(*) FROM modelt WHERE p.`name`=t.`name` AND DATE_FORMAT(t.arrivetime,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m') AND t.`projectid` = 1) AS `arri`
FROM project p
WHERE p.statu = 1 and p.projectid=1
ORDER BY p.id ASC
