select a.* , b.site_user_name,b.site_user_pwd,b.site_user_id,b.site_user_url
from bb_site a left join bb_site_user b 
on a.site_id = b.site_id and b.user_id = 2648 and b.com_id = 2713
where a.site_state = 1  and a.site_type <> 'B2B' and b.site_user_url <> ''