Get records from table using join, see my tables and result

I have two table first website and second event_website_subscription. Please check table screen-shot

I need result like this:-

id, title, created_at, updated_at, subscribe

Case: subscribe value should be add if user has subscriber the website otherwise query return all website list

via Chebli Mohamed