Zafer Bilim Araştırma ve Kültür Dergisi
SELECT u.*,COUNT(p.id) as postCount FROM users as u LEFT JOIN post as p ON p.userID = u.id and p.status = 1 WHERE u.seo = 'aytenyadigar' GROUP BY u.id