Releted product in php

I want to show releted product category or sub category. But confused how to create sql query. I create two table category and sub category. If customer select sub category then categories product show. If any body solve this question. Recommended base e-commerce store create