custom user meta query

by

Actually i figured it out now using join

SELECT a.ID FROM wp_users a INNER JOIN wp_usermeta b ON b.user_id = a.ID AND 
(
( b.meta_key = 'firstname-groom' AND b.meta_value LIKE 'Darren' )
OR ( b.meta_key = 'firstname-bride' AND b.meta_value LIKE 'Someone' )
OR ( b.meta_key = 'lastname-bride' AND b.meta_value LIKE 'Cool' )
)
INNER JOIN wp_usermeta c ON c.user_id = a.ID AND 
( c.meta_key = 'weddingdate' AND c.meta_value="12/14/2014" )
GROUP BY a.ID