so what i want is that, when this query returns its values, i only want it to return user_id of users that registered 7days now,
so i know that there is a users table wp_users in this table, there is a column user_registered  that hold the date the user registered,
i also know of user_registered>= DATE(NOW()) - INTERVAL 7 DAY and user_registered<= now()
but i dont know how to combine all these to achieve my result, i would be glad if you could help.. Thanks

 SELECT user_id  FROM wpcg_usermeta WHERE meta_key = 'user_parent' AND meta_value = 2