SELECT
    category.category_id AS category_id,
    image.filename AS image,
    category.parent_id AS parent_id,
    category.path AS path,
    category.sort_order AS sort_order,
    category.date_added AS date_added,
    category.date_modified AS date_modified
RIGHT JOIN image
ON
    category.image_id=image.image_id;