SELECT
u.ID AS user_id,
u.user_login,
u.display_name,
COUNT(p.ID) AS lagoon_count
FROM wp_users u
Lagoons by @Mango
-
SQL
SELECT
u.ID AS user_id,
u.user_login,
u.display_name,
COUNT(p.ID) AS lagoon_count
FROM wp_users u